This solution worked for me: http://www.bennadel.com/blog/1903-Parsing-CSV-Data-With-ColdFusion-s-CFHTTP-Tag.htm
On Thu, 03 Jun 2010 14:27:08 -0400, Paul Henderson <p...@smashedvision.com> wrote: > Thanks for the replies, it seems like I'm taking the wrong approach. > > Currently I am using a cfloop to loop over the file, then > > #listgetat(FileLine,1)# to reference each field. > > > > <cfloop file="C:\CSVs\2010-05-21.csv" index="FileLine"> > > <cfset record_type = '#listgetat(FileLine,1)#'> > > </cfloop> > > > > It seemed like a pretty simple solution and was working fine until I came > > across fields with commas. As far as I can tell I can't use "'" as the > > delimiter with listgetat. Does anyone have a better approach? Thanks again. > > > > > > On Thu, 3 Jun 2010 10:37:34 -0700, Judah McAuley <ju...@wiredotter.com> > > wrote: > >> Any delimited file that has delimiters contained within a field is > >> supposed to use a text qualifier. For CSV, the most common qualifier > >> is double quotes, so your file would look like: > >> > >> "1234","field 1","my big field, that has a delimiter or two, but is > >> qualified" > >> > >> If there are not text qualifiers and a field includes a qualifier then > >> it isn't a valid csv file. If it is qualified, you should break the > >> line up using the compound string "," as what you are splitting on, > >> then remove the first and last qualifiers. > >> > >> Hope that helps, > >> Judah > >> > >> On Thu, Jun 3, 2010 at 10:32 AM, <p...@smashedvision.com> wrote: > >>> > >>> I'm trying to import a comma delimited CSV file using <cfloop > >>> > >>> file="filename.csv">, but some records contain commas and they are > >>> throwing > >>> > >>> everything off. I can't seem to figure out how to replace the in-field > >>> > >>> commas without messing up the delimiter. Any ideas? Thanks in advance. > >>> > >>> > >>> > >>> -Paul > >>> > >>> > >> > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
