http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt266.jsp#1111342
-----Original Message----- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 3:16 PM To: CF-Talk Subject: OT: MS Access - Replace a specific string value Hi all - I've run into something I cant quite put my finger on yet. Does anyone know a function to find the first instance of a specific character in a string and replace it with another string value. In my case I want to find the first instance of a comma " , " and replace it with a blank " ". Im doing this so when I export a file without a text delimiter it will not break the field into two separate columns. Thanks everyone! Casey Cook ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
