Replace a string with a pound sign in it

[junkjones]

Hi everyone,

I am pulling some HTML from a site and using the Replace() function to format it. However, anything with a hex value in it confuses CF.

Here is what I want to do:

<CFSET MyChart = #Replace(Mychart, '<TD bgcolor=#FFFFFF>', '<TD bgcolor=#000000>', 'ALL')#>

However, the replace function gets confused with the pound signs (understandably). I have tried escaping the pound signs (##). I then don't get an error, but it doesn't run the replace function because it can't find a match.

Has anyone figured out a work around for this? Thanks!

 

[soloa]

Did you try using the ascii code for the hash character like?...

<CFSET MyChart = #Replace(Mychart, '<TD bgcolor=' & chr(35) & 'FFFFFF>', '<TD bgcolor=' & chr(35) & '000000>', 'ALL')#>