11-29-2007 12:49 PM
Hi. Is there any way to remove special characters like
'
or`
or´
from a string.tést
intotest
for exampleThanks in advance
11-29-2007 12:51 PM
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
ec
11-29-2007 12:51 PM
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
ec