moissinac / csvfix

Automatically exported from code.google.com/p/csvfix
MIT License
0 stars 0 forks source link

Line feeds in quoted fields are not parsed properly in read_dsv #17

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Input file:

Test|Test2|"
"|Test 3

Expected output:

"Test","Test2","
","Test 3"

Actual Output:

"Test","Test2",""""
"""","Test 3"

Original issue reported on code.google.com by mela...@t-data.com on 13 Jun 2010 at 8:55

GoogleCodeExporter commented 8 years ago
In DSV files, in CSVfix and elsewhere, the linefeed is always the record 
terminator - it cannot appear within a record.

Original comment by nbutterworth1953@gmail.com on 2 Jul 2010 at 10:47

GoogleCodeExporter commented 8 years ago
Outlook produces fields that contain linefeeds. They are created by exporting 
contacts to comma separated files. The comments fields contain line feeds and 
those are placed in the file, causing import/conversion to fail.
Of course, it's up to you to ignore the market leader.

Original comment by mela...@t-data.com on 2 Jul 2010 at 10:54

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
CSVfix supports linefieeds in CSV files, but not in DSV ones. If you want to 
discuss this further, please use the support group at 
http://groups.google.com/group/csvfix

Original comment by nbutterworth1953@gmail.com on 5 Jul 2010 at 2:21