Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ascii code

Hi all,

if i have a string, like "exposé" and i want to replace the "é" by "e", and i want to do this with several other accented vowels, i assume i need the ascii code (in this case) for the "é" and then replace it with the "e", right ?

Thanks for some advise.

regards, k

2 Replies
Miguel_Angel_Baeyens

Hi,

It all depends on how do you want to make the change. I don't know how difficult it can take but you can use MapSubString function with a mapping table that states each non ascii standard character with its correspondence. You will have to use that function in the script and for all fields that are subject to these characters.

Hope that gives you an idea.

Miguel

schivet
Contributor III
Contributor III

Hi,

If you do a mapping:

MAP_asci:
mapping load * inline [
from,to
é, e
è, e
ä, a
ö, o
å, a
ó, o
' ', '.' ]
;

and in the load:

If(Len(Trim(sn))=0, ' ', mapsubstring('MAP_asci', lower(givenName)) & '.' & mapsubstring('MAP_asci', lower(sn)) & '@zurich.com')  as [Email (from Name/Surname)]


It will work