jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
152 stars 28 forks source link

Multiline value has no delimiters between items #35

Closed lospejos closed 1 year ago

lospejos commented 2 years ago

Multiline value has no delimiters.

Please find attached screenshot. First column of first line (except header line) contains multiline value in double quotes:

a;b;c
"You should see this
multiline
text
in
one row
of
column a";Text for b;Text for c

Words before newline delimiter has no space after, f.e. words text and in are joined to single textin and so on.

image

jokedst commented 1 year ago

Well, there are no spaces in the file. Do you expect CsvQuery to replace newlines with spaces? It actually retains the newlines, but they don't show up in the GridView. Copy-paste the text from the box and you'll see that the newlines are still there.