Using PurgeChar function to detect specific characters

[thanhng34]

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

[Brett_Bleess]

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