DSV delimiter detection should deprioritize or ignore content-less rows #3198

New Issue

sheetjs · 2024-09-08T13:18:26Z

sheetjs commented

2024-09-08 13:18:26 +00:00

Foo;Bar;Baz
A;1;2
B;3;4
C;5;6
D;7;8
,,
,,
,,
,,
,,
,,
,,

The DSV parser guesses the , delimiter due to the excessive use of commas. This CSV was generated by a third-party writer that erroneously used commas instead of semicolons for the blank rows.

``` Foo;Bar;Baz A;1;2 B;3;4 C;5;6 D;7;8 ,, ,, ,, ,, ,, ,, ,, ``` The DSV parser guesses the `,` delimiter due to the excessive use of commas. This CSV was generated by a third-party writer that erroneously used commas instead of semicolons for the blank rows.

Sign in to join this conversation.