Using PurgeChar function to detect specific characters

thanhng34 — Sat, 16 Nov 2024 19:08:57 GMT

I would like to create a flag to detect if the "Firstname" field ("Prénom" in french) contains specific elements, apart from alphabetic characters, '-' and spaces.
So I wrote the following expression:

If(len(PurgeChar([Prénom],'ABCDEFGHIJKLMNOPQRSTUVWXYZ- '))>0,1,0) as FlagErrorFN

Result : Some first names were identified errors (1) even though they does not contain any specific character (ANAS, MAVA, RAPHALLE, NAMA).

It seems like Qlik does not understand that I wanted to remove spaces with PurgeChar, and those names were identified errors because they contain some spaces before or after the name. For example, when I created a flag with Len(Prénom), it gave 5 for "ANAS", "MAVA", "NAVA" in stead of 4 so I think that these names contain spaces.

Could someone tell me what I have to write correctly to detect if the field "Prénom" does contain a specific character different of alphabetic charac, '-' and spaces ?

Thanks so much for your help,

Thanhng34

Re: Using PurgeChar function to detect specific characters

Brett_Bleess — Thu, 05 Mar 2020 20:03:20 GMT

The only thing of which I can think is there is a space on those names in question, most likely at the end of the name would be my hunch, should be pretty easy to test by excluding that character to see what impact that has on things... Best I have with what you have left here. It would be more helpful if you could attach an app folks could dig into things further.

Regards,
Brett

topic Using PurgeChar function to detect specific characters in QlikView

Using PurgeChar function to detect specific characters

Re: Using PurgeChar function to detect specific characters