On Tue, 24 Mar 2009 09:07:05 -0500, Peter da Silva <[email protected]>
wrote:
> On 2009-03-24, at 07:03, Philip Newton wrote:
> > In Excel's little sub-dialect, for example, quotation marks around a
> > field escape not only the field delimiter but also the record
> > delimiter.
>
> As they should.
>
> > Another fun little hateful fact about Excel is that CSV is really
> > "locale-specific list separator separated values";
>
> Oh, god, I need to update my CSV converter.
Note that the CSV definition only allows single-byte characters as
field separator character, quotation character and escape character.
This means that using \N{FULLWIDTH COMMA} as separation character,
\N{FULLWIDTH QUOTATION MARK} for quotation character and \N{SYMBOL FOR
ESCAPE} for escape character are not allowed. I expect M$ to break this
rule :)
--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, SuSE 10.1, 10.3, and 11.0, AIX 5.2, and Cygwin.
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
