Re (tilly) 1: CRLF in a csv

Are you sure that embedded returns are a problem for Excel?

Save the following file as a .csv file and try to read in Excel. Based on past experience with Excel and Access I believe that it will work properly, despite the freeform fields:

name,status,comment
Barney,0,"Shot, now dinosaurs are really extinct!"
Popeye,1,"If he starts singing, ""I'm Popeye the sailor man...""
look out for the spinach!"
"Snow White",9,"Much better looking than the dwarves!"
[download]

Note the embedded double-quotes...

Comment on Re (tilly) 1: CRLF in a csv Download Code

Replies are listed 'Best First'.
Re: Re (tilly) 1: CRLF in a csv by geofisch (Initiate) on Apr 05, 2001 at 17:37 UTC
You, too, are correct. Excel handles embedded returns in .csv files without a problem. The default extension for the exported file is .asc, so I was trying to import it into Excel with that name. If I rename the file first, Excel does a much better job. Thanks. Oh well. At least I learned about Text::ParseWords.	[reply]