Re: correct escapes in csv-Update files

2008-01-06 Thread Yonik Seeley
OK, the current solr dev version should now work correctly w.r.t. CSV. I ended up rewriting the commons-csv escaping so that normal CSV encapsulation can be handled, but also an escape can be specified for standard backslash style escaping. Leading + trailing whitespace is now also preserved, so o

Re: correct escapes in csv-Update files

2008-01-04 Thread Yonik Seeley
Here's the commons-csv bug for those who want to follow along: http://issues.apache.org/jira/browse/SANDBOX-206 -Yonik On Jan 4, 2008 12:03 PM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > On 04.01.2008 17:35 Walter Underwood wrote: > > > I recommend the opencsv library for Java or the csv pack

Re: correct escapes in csv-Update files

2008-01-04 Thread Michael Lackhoff
On 04.01.2008 17:35 Walter Underwood wrote: > I recommend the opencsv library for Java or the csv package for Python. > Either one can write legal CSV files. > > There are lots of corner cases in CSV and some differences between > applications, like whetehr newlines are allowed inside a quoted fi

Re: correct escapes in csv-Update files

2008-01-04 Thread Walter Underwood
I recommend the opencsv library for Java or the csv package for Python. Either one can write legal CSV files. There are lots of corner cases in CSV and some differences between applications, like whetehr newlines are allowed inside a quoted field. It is best to use a library for this instead of ha

Re: correct escapes in csv-Update files

2008-01-04 Thread Yonik Seeley
On Jan 4, 2008 4:08 AM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > Thanks for the hint but the result is the same, that is, ""quoted"" > behaves exactly like \"quoted\": > - both leave the single unescaped quote in the record: "quoted" > - both have the problem with a backslash before the escape

Re: correct escapes in csv-Update files

2008-01-04 Thread Michael Lackhoff
On 03.01.2008 17:16 Yonik Seeley wrote: > CSV doesn't use backslash escaping. > http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm > > "This is text with a ""quoted"" string" Thanks for the hint but the result is the same, that is, ""quoted"" behaves exactly like \"quoted\": - both leave the s

Re: correct escapes in csv-Update files

2008-01-03 Thread Yonik Seeley
CSV doesn't use backslash escaping. http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm "This is text with a ""quoted"" string" -Yonik On Jan 2, 2008 8:21 AM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > I use UpdateCSV to feed my data into SOLR and it works very well. The > only thing I don't

correct escapes in csv-Update files

2008-01-02 Thread Michael Lackhoff
I use UpdateCSV to feed my data into SOLR and it works very well. The only thing I don't understand is how to properly escape the encapsulator and the backslash. An example with the default encapsulator ("): "This is a text with a \"quote\"" "This gives one \ backslash" "This gives two backslashes