CSV misinterpreted #3083

New Issue

enboig · 2024-03-07T08:59:19Z

enboig commented

2024-03-07 08:59:19 +00:00

I have a CSV separated using , and text using ". Some lines have tabs \t inside text, and it causes errors because \t is assumed as separator.

I think this is an error because text inside " should be completely ignored.

I have a CSV separated using `,` and text using `"`. Some lines have tabs `\t` inside text, and it causes errors because \t is assumed as separator. I think this is an error because text inside `"` should be completely ignored.

enboig commented

2024-03-07 09:02:00 +00:00

I upload a simple example to replicate it.

example.csv

53 B

sheetjs commented

2024-03-09 16:57:41 +00:00

Cannot reproduce. Are you using the latest version of the library?

To be sure, the file in question is 53 bytes and has a MD5 checksum of a5cc2a2517cf85c99bdc05bf12f9856c:

$ wc -c example.csv 
      53 example.csv
$ md5 example.csv 
MD5 (example.csv) = a5cc2a2517cf85c99bdc05bf12f9856c

You can test in NodeJS by running the following commands in WSL or in mac/linux terminal:

mkdir i3083
cd i3083/
npm i --save https://cdn.sheetjs.com/xlsx-0.20.1/xlsx-0.20.1.tgz
node -pe 'var XLSX = require("xlsx"); var wb = XLSX.readFile("../example.csv"); XLSX.utils.sheet_to_json(wb.Sheets.Sheet1, {header:1})'

The output is consistent with a comma delimiter:

[
  [ 'field1', 'field2', 'field3' ],
  [ 'value1', ' "\t\tvalue2"', 'value3\t\t' ]
]

Cannot reproduce. Are you using the latest version of the library? To be sure, the file in question is 53 bytes and has a MD5 checksum of `a5cc2a2517cf85c99bdc05bf12f9856c`: ```bash $ wc -c example.csv 53 example.csv $ md5 example.csv MD5 (example.csv) = a5cc2a2517cf85c99bdc05bf12f9856c ``` You can test in NodeJS by running the following commands in WSL or in mac/linux terminal: ```bash mkdir i3083 cd i3083/ npm i --save https://cdn.sheetjs.com/xlsx-0.20.1/xlsx-0.20.1.tgz node -pe 'var XLSX = require("xlsx"); var wb = XLSX.readFile("../example.csv"); XLSX.utils.sheet_to_json(wb.Sheets.Sheet1, {header:1})' ``` The output is consistent with a comma delimiter: ```js [ [ 'field1', 'field2', 'field3' ], [ 'value1', ' "\t\tvalue2"', 'value3\t\t' ] ] ```

enboig commented

2024-03-14 11:12:02 +00:00

I use dropsheet, this is a capture from json sent from example.csv

dropsheet.png

6.0 KiB

Sign in to join this conversation.