When i have situations like that, I usually replace the offending character with some non-conflicting char, like the system bell. Then after I'm done processing, just switch it back to the original character. You know nothing is going to have that char in it naturally, so a simple call to replace() will take care of it.
Dirty hack, but very effective. HTH, barneyb > -----Original Message----- > From: "Parker [mailto:"Parker] > Sent: Wednesday, February 12, 2003 3:30 PM > To: CF-Talk > Subject: Apostrophe > > > I've set up an app that takes a CSV file from ACT ("Name", "EmailAddress") > and loops through a query created with CFHTTP (see code snippet below) and > sends each person on the list the email. Part of the loop that does this > checks for a validly constructed email address. If its not validly > constructed then it doesn't send an email but populates a report (with > CFFILE) and reports that back to the business area so that they > can rectify > the problem. The process came unstuck when it encountered a name > and address > with an apostrophe (I have attached much suspicion to this row). I'm not > sure if it was the apostrophe in the name or the address that > caused it but > every row below (and including) that in the CSV file crashed out > (I suspect > the apostrophe may have corrupted CF's understanding of the > construction of > the CSV file???). Any tips on how I can trap this problem please. > > > > <cfhttp url="http://domain_name/loop/#AddressFile#"; > method="GET" > name="Addresses" > columns="Subscriber,Address" > textqualifier="""" > delimiter="," > resolveurl="false"> > > > TIA!!!! > > > > ********** > Kevin Parker > Web Services Manager > WorkCover Corporation > > 08 8233 2548 > 0418 806 166 > > [EMAIL PROTECTED] > ********** > > > > ************************************************************************ > This e-mail is intended for the use of the addressee only. It may > contain information that is protected by legislated confidentiality > and/or is legally privileged. If you are not the intended recipient you > are prohibited from disseminating, distributing or copying this e-mail. > > Any opinion expressed in this e-mail may not necessarily be that of the > WorkCover Corporation of South Australia. Although precautions have > been taken, the sender cannot warrant that this e-mail or any files > transmitted with it are free of viruses or any other defect. > > If you have received this e-mail in error, please notify the sender > immediately by return e-mail and destroy the original e-mail and any > copies. > ************************************************************************ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
