Line feeds in CSV values

[mdruiter]

The database viewer plugin supports a "Text qualifier". However, line feeds are always regarded as line separators, even if between text qualifiers like (double) quotes. This way, many CSV files cannot be read comfortably.
Fixing this would make a much more complete CSV viewer.

[Jan Patera]

The database viewer plugin supports a "Text qualifier". However, line feeds are always regarded as line separators, even if between text qualifiers like (double) quotes. This way, many CSV files cannot be read comfortably.
Fixing this would make a much more complete CSV viewer.

Huah. Many? These are strange files. Can you send a sample to the support email address?
P.S. This is the wrong forum for reporting bugs

[SelfMan]

Jan, he is true. I've had these problems while coding websites/web-aplications which used CSV files.
The problem is that the viewer ignores a situation where a carrrriage return/line feed is a part of the content...
Like this:

Code: Select all

"a";"b";"c";"d"
"aa";"bb";"cc";"dd"
"a
aa";"b
bb";"c
cc";"d
dd"

This is a valid CSV because the carriage return is within quotes.
I admit, ms excel is in this case stupid too.

[Jan Patera]

The database viewer plugin supports a "Text qualifier". However, line feeds are always regarded as line separators, even if between text qualifiers like (double) quotes. This way, many CSV files cannot be read comfortably.
Fixing this would make a much more complete CSV viewer.

Multi-line values inside "text qualifiers" will be supported in the next release of Altap Salamander (2.52).

[SelfMan]

*thumbs-up*

[mdruiter]

I finally noticed that it actually works.
Great!