topic Re: Suppress/remove accents from a text string in QlikView

Suppress/remove accents from a text string

Wed, 11 Jul 2012 21:28:12 GMT

Hi Guys,

Does anyone know how to remove accents or diacritics from a text string? For instance, I want the following string áéíóú to appear as aeiou.

I'm ideally looking for a solution that I can employ with set analysis as opposed to on import. Any ideas if there's a similar function to UPPER and LOWER, but for removing accents?

Any insight will be much appreciated.

Matt

Re: Suppress/remove accents from a text string

swuehl — Wed, 11 Jul 2012 21:41:07 GMT

Set analysis is creating a different set of field selections in the context of an aggregation function, so you can compare it to making selections, select records. I don't think you can use it to modify data values.

There might be a solution in the front end, but I personally would use a mapping table and mapsubstring in the load script to replace the characters. You can create an additional field in your load, so you can hold both the original and manipulated strings.

Re: Suppress/remove accents from a text string

Thu, 12 Jul 2012 00:42:43 GMT

Thanks!

I saw another post with a mapping solution. Looks like that's my best option.

Thanks again,

Matt

Re: Suppress/remove accents from a text string

schivet — Fri, 16 Sep 2016 13:57:30 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