Thanks. I'll check it out. I got it working last night. Its ugly, but it works.
Quoting Mike Townend <[EMAIL PROTECTED]>: > Theres a custom tag that might be of use to you, CFX_CSVToQuery takes a > CSV file and converts it into a query object for you.. It handles comma s > in "" > > HTH > > > > -----Original Message----- > From: Tracy Bost [mailto:[EMAIL PROTECTED]] > Sent: 21 February 2002 22:40 > To: CF-Talk > Subject: Get everything between " " in a CSV file. > > > Can someone help me out here. I have a cvs file being uploaded and am > having trouble with one of the fields. It a field that *can* contain > comments and therefore have a comma in it. I'm dumping it into the > database and > everything is hunky dorie until a comma is put in the comment field. I > notice > the csv file puts this field like this "This is a comment, and another > comment,and another"... I would like to find all commas between the two > " " and > temporarily change the commas to something else so it doesn't think its > another > field... > > Using the ListChangeDelims function doesn't get it because it changes > those > commas in the comment also. > > > > Thanks, > > - Tracy > > ----------------------------------------------------------------------- - > ------ > Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com Get > the latest on Ag News, Market Reports, FREE email, and much more. > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
