[ 
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

Reply via email to