Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Remove special characters

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

JozsefSzikszai
Active Contributor
0 Kudos

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

1 REPLY 1

JozsefSzikszai
Active Contributor
0 Kudos

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