CSV with newlines inside quoted field does not work

[Hipska]

While #4 has been marked as resolved, it still doesn't seem supported or working as expected.

Given the same example CSV:

Key,Text
X,"Hello, mechatroner,
This, incorrectly interpreted as a new row with two columns"

Results in this with current version 3.23.0:

This results in also the align option not to work as it gives the following error:

Caution

Unable to align: Inconsistent double quotes at line 2

[mechatroner]

The problem most likely is failed autodetection - multiline fields work only with "dynamic_csv" filetype, but not with CSV - what filetype does it show in the bottom right corner for you? I guess this sounds a bit strange but there are benefits to this approach and in most cases autodetection would set the filetype correctly to "dynamic_csv" when it parses a file with multiline fields. Autodetection sometimes doesn't work correctly when file is too small or when it was typed-in manually. I believe even pasting CSV data into an empty file should trigger autodetection in most cases.

[Hipska]

It seems indeed to work in dynamic mode. Why doesn’t it work in regular (comma, semicolon, …) mode?