topic Re: Find single lower letter in QlikView

Find single lower letter

Fitus9092 — Fri, 10 Sep 2021 06:37:45 GMT

Hello guys,

i need to find if a field has a single lower letter. For example: "HOUsE", i want something that says to me "This word has a lower letter". Can't use the function lower or upper because they change all letters in a word.

I have tried if(wildmatch(FIELD, '*a*', '*b*',...) ,1,0) as check but it find upper letters too and not only lower.

thanks.

Re: Find single lower letter

lironbaram — Fri, 10 Sep 2021 07:35:08 GMT

Hi
I don't know about singe lower letter ,
but If you are looking for an expression to see if there is any amount of lower letters in a word
This will do the trick :

In the below expression the Field is call Word.

if(upper(Word)<>Word,'there is a lower letter in the word','No lower letters found')

Re: Find single lower letter

Fitus9092 — Fri, 10 Sep 2021 08:31:29 GMT

Work, thanks!