topic Re: ascii code in QlikView

ascii code

Fri, 22 Jun 2012 12:39:08 GMT

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

Re: ascii code

Miguel_Angel_Baeyens — Fri, 22 Jun 2012 12:49:09 GMT

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

Re: ascii code

schivet — Fri, 16 Sep 2016 14:04:32 GMT

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