Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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')
Work, thanks!