Replacing special character ’

[minli98]

Hi,

Does anyone know why when I run #chr(asc(’))# I get â instead of the original character ’? FYI, this character is the single quote in Microsoft Word. I am trying to replace it with the regular single-quote ' but I am having a hard time. I tried using #replace(strVal,"’","'","all")# but it didn't work.

Many thanks.

Min

 

[minli98]

Sorry, a small typo in the original post.

Does anyone know why when I run #chr(asc("’"))# I get â instead of the original character ’? FYI, this character is the single quote in Microsoft Word. I am trying to replace it with the regular single-quote ' but I am having a hard time. I tried using #replace(strVal,"’","'","all")# but it didn't work.

Many thanks.

Min

 

[philhege]

Google for "Smart Quotes". It's a special character that gets interpreted by Word as left-slant/right-slant, like

“Hello” ‘Hello’ (I pasted this from Word. Load it into a hex editor and inspect the hex value of the characters.)

Use the replace() function to fix these.

Phil H.
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.

 

[minli98]

Thanks. I figured it out.

Rgds,
Min