Escaped quotation marks of CSV fail on dropsheet #3089

New Issue

enboig · 2024-03-14T11:19:18Z

enboig commented

2024-03-14 11:19:18 +00:00

I am using dropsheet, and with included file escaped quotation \"are escaped, but read next , as field separator.

I am using dropsheet, and with included file escaped quotation `\"`are escaped, but read next `,` as field separator.

test2.csv

99 B

dropsheet2.png

9.8 KiB

sheetjs commented

2024-03-20 03:19:15 +00:00

The correct way to embed double quotes in strings is to repeat the double quotes.

field1,field2,field3
"aaa","Lorem ""ipsum"" dolor sit amet, consetetur","bbb"
"ccc","ddd","eee"

You can discover this by entering the data in a worksheet in Excel and saving to CSV.

The correct way to embed double quotes in strings is to repeat the double quotes. ``` field1,field2,field3 "aaa","Lorem ""ipsum"" dolor sit amet, consetetur","bbb" "ccc","ddd","eee" ``` You can discover this by entering the data in a worksheet in Excel and saving to CSV.

sheetjs closed this issue

2024-03-20 03:19:15 +00:00

Sign in to join this conversation.