Thank you for your help. I used <cfoutput>#ASC("funky_character")#</cfoutput>
to find out which character it was. Then I used your code to replace it:
<cfset TextAreaAmended1= ReplaceNoCase(#form.textarea#,"#chr(25)#","'",
"All")> . It worked great. Thanks again!
> How do you replace that funny square character with an apostrophe? I
> have people entering data into a form textarea. The data is inserted
> into MS Access and then displayed on a page. There are times when the
> apostrophe shows up as a square character.
>
> Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3273
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15