Casey C Cook writes: > 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.
replace(myString, ",", " ", "one") should do it. charlie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
