Removing pound signs from a string

2005-07-15 Thread Michael Dinowitz
In truth all you have to do is double the pound signs so Replace(string, '##', '', 'all') should do it. It will replace every single pound within your text with a double pound, ignoring everything else. Well as a last resort I thought I could put the offending code in a CFTRY and just lose

RE: Removing pound signs from a string

2005-07-15 Thread Dan G. Switzer, II
Michael, In truth all you have to do is double the pound signs so Replace(string, '##', '', 'all') should do it. It will replace every single pound within your text with a double pound, ignoring everything else. I was under the impression that he had other code that might have valid CFML, so

RE: Removing pound signs from a string

2005-07-15 Thread Michael Dinowitz
I was under the impression that he was only looking to escape the pound sign in a SKU string. If the string is more than that, then you are correct and much more care is needed. I was under the impression that he had other code that might have valid CFML, so doing a blanketed replace would

Removing pound signs from a string

2005-07-14 Thread Karl Simanonok
Well as a last resort I thought I could put the offending code in a CFTRY and just lose a few records once in a while, but trying to remove a # sign from a string will even bomb a CFTRY! Somehow I have to be able to get past this obstacle. Barney B. suggested this regular expression but it