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 doesn't work and all the logical variants I
can think of don't work either: REreplace(myText, '"([^"]*)##([^"]*")',
"\1####\2", "all")
This was my original question, hopefully someone out there will have dealt
with something like this before:
I've got a compiled application that can be programmed to output ColdFusion
code along with its regular output, writing CF templates that later run
under CF 5.0. However if any of its regular output contains pound signs,
CF throws an error when the template is executed. Both these examples will
fail:
<CFSCRIPT>
Test = 'SKU # 1716-SY-367';
</CFSCRIPT>
Or
<CFSET Test = 'SKU # 1716-SY-367'>
What I would LIKE to do is use Replace or REReplace or somehow escape the
damn pound signs out of the strings more or less like so:
<CFSET Test = #REplace("SKU # 1716-SY-367", "#Chr(35)#", "", "ALL")#> --
but it doesn't work.
(#Chr(35)# in the REplace function will replace say, DOUBLE pound signs in
the string, so at least that works)
It is not possible to use the original compiled application to either
double up the pound signs or eliminate them, I have to work with the output
it gives me and it isn't very sophisticated. I can use it to output any CF
code I want but I have to deal with the strings it gives me. Any help
will be greatly appreciated.
Regards,
Karl S.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 7/14/05
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211950
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54