in reply to Write array contents to csv file

Hi,

I created a tab delimited file using notepad, and saved it with a .csv extension.

I opened it it Excel and the tabs were missing.

I then copied it and changed the extension to .txt.

The tabs were there in Excel ( after a bit of palaver ).

Might solve the problem, might not.

J.C.

Replies are listed 'Best First'.
Re^2: Write array contents to csv file
by marinersk (Priest) on Jul 16, 2013 at 15:33 UTC
    Ah, yes, that's right, Excel leans on the file type in the name more heavily than expected in some cases.

    Might be that merely naming the file with a .CSV type is masking the operation.

    Good catch.

[reply]

In Section Seekers of Perl Wisdom