I found the solution. I was cleaning up the chr(10) and 13s and then appending them to a list. If you clean out the offending characters AFTER building the list, it all works fine.
-----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:01 PM To: CF-Talk Subject: RE: Replacenocase doesn't replace chr(10)? Hmmm. Anyone have any ideas? I still see chr(10) after running replacenocase. Could it be combined with another chr type that somehow escapes it? -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:58 PM To: CF-Talk Subject: RE: Replacenocase doesn't replace chr(10)? it does. for proof run the following code: -------------------------- <cfset foo = "#chr(10)#asdfasdf"> <cfset temp = find(chr(10),foo)> <cfoutput>#temp#</cfoutput> <cfset foo = replaceNoCase(foo,chr(10),"","all")> <cfset temp = find(chr(10),foo)> <cfoutput>#temp#</cfoutput> --------------------------------- your problem must lie elsewhere... +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:48 PM To: CF-Talk Subject: Replacenocase doesn't replace chr(10)? Hi all, I've got some code: <cfset insertstring = replacenocase(insertstring,chr(10),"","ALL")> As far as I can tell, this SHOULD replace any chr(10)s. But when I run the template it leaves them in the text, and it's screwing up my Excel imports. I know that the chr(10) is to blame, because I've looped through the string in question character by character, and it's the only special character left. help? Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
