<cfset newstring = replace(string, ",", " ", "ONE")> or leaving scope blank (default is one) <cfset newstring = replace(string, ",", " ")>
----- Original Message ----- From: "Casey C Cook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 3:15 PM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
