[ https://issues.apache.org/jira/browse/SOLR-1925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888817#action_12888817 ]
Yonik Seeley commented on SOLR-1925: ------------------------------------ I tried excel 2003 and excel 2007 - both work fine with embedded newlines. Perhaps you're not encoding your test file correctly. > > AFAIK, the CSV spec doesn't recommend always using encapsulators. > See here: http://en.wikipedia.org/wiki/Comma-separated_values, 1st Paragraph: > Fields that contain a special character (comma, newline, or double quote), > must be enclosed in double quotes. I'll repeat: "the CSV spec doesn't recommend always using encapsulators". Why do you keep suggesting that it does? > > If we do things correctly, we should be able to round-trip with > > http://wiki.apache.org/solr/UpdateCSV > What's your rationale that this isn't compatible with that? Have you tried > it? I didn't need to try it... I just looked at this patch, which doesn't do proper CSV encoding/escaping. > What's the host-independent way to do System.getProperty("line.separator")? You pick one (like \n)... if there is a need for a different one, you let it be configured / specified by the client. > CSV Response Writer > ------------------- > > Key: SOLR-1925 > URL: https://issues.apache.org/jira/browse/SOLR-1925 > Project: Solr > Issue Type: New Feature > Components: Response Writers > Environment: indep. of env. > Reporter: Chris A. Mattmann > Assignee: Erik Hatcher > Fix For: Next > > Attachments: SOLR-1925.Chheng.071410.patch.txt, > SOLR-1925.Mattmann.053010.patch.2.txt, SOLR-1925.Mattmann.053010.patch.3.txt, > SOLR-1925.Mattmann.053010.patch.txt, SOLR-1925.Mattmann.061110.patch.txt > > > As part of some work I'm doing, I put together a CSV Response Writer. It > currently takes all the docs resultant from a query and then outputs their > metadata in simple CSV format. The use of a delimeter is configurable (by > default if there are multiple values for a particular field they are > separated with a | symbol). -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org