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. ______________________________________________________________________ Dedicated Windows 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=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists