Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jozisvk11
Creator
Creator

Find small letter in word

Hello, could you tell me, if we have function in qlikview, which can find small letter in words. For Example:

City               YES/NO small letter

LONDOn               YES

PRAGUE               NO

bERLIN                 YES

PaRIS                   YES

MADRID                NO

etc.

Thank you for your comment. 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

If(FindOneOf(City, 'abcdefghijklmnopqrstuvwxyz'), 'YES', 'NO')  as  [YES/NO small letter]

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

If(FindOneOf(City, 'abcdefghijklmnopqrstuvwxyz'), 'YES', 'NO')  as  [YES/NO small letter]

swuehl
MVP
MVP

Alternatively, this should also work:

If(Upper(City)=City, 'NO','YES') as Flag