Page 1 of 1

Line feeds in CSV values

Posted: 25 Jul 2008, 10:55
by 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.

Re: Line feeds in CSV values

Posted: 25 Jul 2008, 14:37
by Jan Patera
mdruiter wrote: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

Re: Line feeds in CSV values

Posted: 26 Jul 2008, 01:11
by 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.

Re: Line feeds in CSV values

Posted: 05 Jan 2009, 15:15
by Jan Patera
mdruiter wrote: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).

Posted: 06 Jan 2009, 00:19
by SelfMan
:D :D :D :D :D :D *thumbs-up*

Re: Line feeds in CSV values

Posted: 18 May 2010, 15:11
by mdruiter
I finally noticed that it actually works. :D
Great!