Line feeds in CSV values

Discussion of bugs and problems found in Altap Salamander. In your reports, please be as descriptive as possible, and report one incident per report. Do not post crash reports here, send us the generated bug report by email instead, please.
User avatar
mdruiter
Posts: 262
Joined: 22 Feb 2006, 15:33
Location: Amsterdam, The Netherlands
Contact:

Line feeds in CSV values

Post 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.
Jan Patera
Plugin Developer
Plugin Developer
Posts: 707
Joined: 08 Dec 2005, 14:33
Location: Prague, Czech Republic
Contact:

Re: Line feeds in CSV values

Post 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
User avatar
SelfMan
Posts: 1142
Joined: 05 Apr 2006, 20:51
Contact:

Re: Line feeds in CSV values

Post 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.
Jan Patera
Plugin Developer
Plugin Developer
Posts: 707
Joined: 08 Dec 2005, 14:33
Location: Prague, Czech Republic
Contact:

Re: Line feeds in CSV values

Post 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).
User avatar
SelfMan
Posts: 1142
Joined: 05 Apr 2006, 20:51
Contact:

Post by SelfMan »

:D :D :D :D :D :D *thumbs-up*
User avatar
mdruiter
Posts: 262
Joined: 22 Feb 2006, 15:33
Location: Amsterdam, The Netherlands
Contact:

Re: Line feeds in CSV values

Post by mdruiter »

I finally noticed that it actually works. :D
Great!
Post Reply