topic Re: Remove special characters in string in Application Development and Automation Discussions

Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:11:39 GMT

Hi all,

I'm Portuguese, and in our language we use special characters in words like "João or "Sónia".

I need to take off these special characters, which means I want to have the same words like "Joao" and "Sonia", without the characters "~" or "´".

Do you have any idea how can I do this?

Thanks in advance.

Best regards,

Sónia Gonçalves

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:14:13 GMT

hi,

language which are viewing is depending on your language at login time. Try to login with "EN" as Language selection you will get the desired output.

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:14:15 GMT

for this use the replace all occurances

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:15:14 GMT

for this use the replace all occurances of

data:char(5) value 'Sónia'.

replace all occurrences of 'ó' in char with 'o' .

write: char.

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:24:07 GMT

Hi,

But I want to make this generic, I don't want to replace character by character.

If I give a string in the program, I want to search all ocurrences of these special characters and replace them.

How can I do this?

Thanks.

Best regards,

Sónia Gonçalves

Re: Remove special characters in string

matt — Thu, 24 Jul 2008 14:26:46 GMT

>I don't want to replace character by character

TRANSLATE string USING 'ÑNñnÓOóo...'.

matt

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:34:00 GMT

Check out this function SCP_REPLACE_STRANGE_CHARS

Re: Remove special characters in string

matt — Thu, 24 Jul 2008 14:37:48 GMT


> Check out this function SCP_REPLACE_STRANGE_CHARS

Very nice. But it replaces Ö Ä Ü with Oe Ae Ue instead of OE AE UE

Seems great with Portugese accents though.

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:40:22 GMT

Maybe it's the codepage? I've only use it to remove accents and the ñ

Re: Remove special characters in string

Former Member — Thu, 24 Jul 2008 14:48:29 GMT

Hi,

The function SCP_REPLACE_STRANGE_CHARS is just what I need!!

Thank you very much for your help!!

Best regards,

Sónia Gonçalves

Re: Remove special characters in string

matt — Thu, 24 Jul 2008 15:01:18 GMT

It's absolutely correct to replace Ö with OE. My point was it's replacing them with Oe.

Re: Remove special characters in string

matt — Fri, 25 Jul 2008 06:17:15 GMT

Sonia -> The points should have gone to Ramiro Escamilla, not me.

matt