Have you logged a JIRA ? Cheers
On Fri, Nov 7, 2014 at 10:35 AM, Radu Marias <[email protected]> wrote: > the fix is against 4.2 branch > > On Fri, Nov 7, 2014 at 8:34 PM, Radu Marias <[email protected]> wrote: > > > I'm importing a cvs file which has values as double-quoted and with comma > > (as the fields separator) also in the value of a field, something like > this: > > > > *"1","Charlie's Auto Body, \" Inc.","N","1-1"* > > > > The first issue is that first field which is a number cannot be parse > like > > one because of the quote. > > If I remove the quotes from csv file than comma from the value field is > > treated as field separator and I get one more extra field, which causes > the > > import to fail. This is because the cvs parser don't parse it from > > double-quoted representation, where it should handle the comma as part of > > the value. > > The PSQL import handles such cases. > > > > I know I can change the comma separator in my files to something else but > > it not the best approach and also you need to first pre process the data > to > > find an unused character to use. > > > > So, I started to look in the code and I come with a fix, attached patch. > > Please share your thoughts if you think this would be a useful feature > and > > I can create a jira issue with the patch. > > The fix includes support to specify quote and escape chars as arguments. > > > > -- > > And in the end, it's not the years in your life that count. It's the life > > in your years. > > > > > > -- > And in the end, it's not the years in your life that count. It's the life > in your years. >
