in reply to Re: Re (tilly) 1: csv output
in thread csv output

Save the following in your text editor and open in Excel to verify the incompatibility. 
hello,world
"this","is "",test 1"
"this","is \",test 2"
"this","is "" test 3"
"this","is \" test 4"

[download]
Note in particular the unusual handling of the even tests.

Replies are listed 'Best First'.
Re: Re (tilly) 3: csv output
by Juerd (Abbot) on Mar 14, 2002 at 20:09 UTC

    That would require me to install Microsoft Windows and acquire and install Microsoft Excel. Could you please tell me how they will be handled? 

    U28geW91IGNhbiBhbGwgcm90MTMgY
W5kIHBhY2soKS4gQnV0IGRvIHlvdS
ByZWNvZ25pc2UgQmFzZTY0IHdoZW4
geW91IHNlZSBpdD8gIC0tIEp1ZXJk

[reply]
      Ah, small problem. The result is as follows:
      helloworld
      thisis ",test 1
      thisis \test 2"
      thisis " test 3
      thisis \ test 4"
      As you see, Excel does not exactly agree with Friedl on what CSV format looks like...
[reply]

        As you see, Excel does not exactly agree with Friedl on what CSV format looks like..

        :( 

        U28geW91IGNhbiBhbGwgcm90MTMgY
W5kIHBhY2soKS4gQnV0IGRvIHlvdS
ByZWNvZ25pc2UgQmFzZTY0IHdoZW4
geW91IHNlZSBpdD8gIC0tIEp1ZXJk

[reply]

In Section Seekers of Perl Wisdom