I think you might have to use a regex on it first. Find everything between " " first, and replace the comma's with something else, maybe a period or something.
I'll look around and see if I can find a better way to do it. _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:40 PM 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
