"this is \"one\" field"
While Excel uses doubling:
"this is ""one"" field"
Cheers,
barneyb
> -----Original Message-----
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 22, 2004 10:29 AM
> To: CF-Talk
> Subject: Re: CSV HELL
>
> Barney Boisvert wrote:
>
> > There's a really nice set of utility classes available at
> > http://www.ostermiller.org/utils/CSV.html that I've used
> with great success
> > for parsing CSV files. It takes care of all the nastiness
> with quotes in
> > Excel CSV files. It also has classes for handling "normal"
> CSV files.
> > Little more work than dropping in a UDF, but it's blazing fast.
>
> You guys are all using the word "normal" wrong here.. Excel produces
> perfectly normal CSV files (amazingly)... Unfortunately, "normal" csv
> files can be rather complex.
>
> Perl has some modules similar to the java classes above that
> handle true
> CSV parsing, and if you expect to ever get a CSV generated by Excel,
> Access, or any variety of other applications, you should
> consider using
> such classes.
>
> You could probably do it like this:
>
> <CFFILE ... VARIABLE="csvdata">
> <cfscript>
> csvinput = CreateObject("java", "java.io.StringReader");
> csvinput.init(csvdata);
> csvparse =
> CreateObject("java","com.Ostermiller.util.CSVParser");
> results = csvparse.parse(csvinput)
> // results = 2 dimensional array of values
> </cfscript>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
