topic Remove special characters in Application Development and Automation Discussions

Remove special characters

Former Member — Thu, 29 Nov 2007 12:49:01 GMT

Hi. Is there any way to remove special characters like

or `
or ´
from a string.

I mean convert: tést
into test
for example

Thanks in advance

JozsefSzikszai — Thu, 29 Nov 2007 12:51:25 GMT

hi Javier,

use the TRANSLATE command:

TRANSLATE string USING 'éeäaöo'.

this means é will be replaced in string with e, ä with a, etc. the pattern after using can be longer of course

hope this helps