Occasionally CFHTTP works very well for these types of files.
http://cfhub.com/advanced/cfhttp/query.cfm
>
> Hiya,
>
> When you do an export from Excel as CSV, you can specify that text cells
are
> qualified by inverted commas, so as to keep any commas in the actual text
> content being interpreted as column delimiters. e.g.
>
> Name, Address, PhoneNum
> "Jez Allaire","1 Tag St, Tagville","555-9102"
>
> Is there an easy way in Cold Fusion to parse this line as a list, and take
> into account the text qualifiers? I'm sure this is a very common need for
> developers...
>
> seeya!
>
> -----------------------
> Ryan Sabir
> Newgency Pty Ltd
> 2a Broughton St
> Paddington 2021
> Sydney, Australia
> Ph (02) 9331 2133
> Fax (02) 9331 5199
> Mobile: 0411 512 454
> http://www.newgency.com/index.cfm?referer=rysig
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
