topic Re: How to identify fields that only contain [A-Z] characters in QlikView

How to identify fields that only contain [A-Z] characters

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I have a column in my data set called Name - this should contain names so values should be characters [A-Z] but unfortunately there are entries such as special characters or numbers.

How can I check if the value only contains characters [A-Z} please?

Thank you

JazzyK

Re: How to identify fields that only contain [A-Z] characters

sunny_talwar — Wed, 18 Jul 2018 16:11:25 GMT

May be like this

If(Len(Trim(PurgeChar(Lower(Name), 'abcdefghijklmnopqrstuvwxyz'))) > 0, 'Contain Special Characters or Numbers', 'Doesn't contain Special Characters or Numbers') as Flag

Re: How to identify fields that only contain [A-Z] characters

atoz1158 — Wed, 18 Jul 2018 16:14:33 GMT

Hi Jasmit

If you want to clear the field then in your load script try using the following

KeepChar(Name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as Name

If you need to keep Spaces then add a space into the list of Characters to keep, also if you wish to keep the lowercase letters as well then added those, the below version will also keep the spaces and lowercase letters.

KeepChar(Name,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz ') as Name

Regards

Adrian

Re: How to identify fields that only contain [A-Z] characters

Anonymous — Wed, 18 Jul 2018 17:26:59 GMT

Thank you. That worked perfectly...

Re: How to identify fields that only contain [A-Z] characters

atoz1158 — Thu, 19 Jul 2018 08:44:57 GMT

Hi Jasmit

To help others if this has now answered your question please mark the correct reply and set it as answered.

Regards

Adrian