Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
If(FindOneOf(City, 'abcdefghijklmnopqrstuvwxyz'), 'YES', 'NO') as [YES/NO small letter]
Try like:
If(FindOneOf(City, 'abcdefghijklmnopqrstuvwxyz'), 'YES', 'NO') as [YES/NO small letter]
Alternatively, this should also work:
If(Upper(City)=City, 'NO','YES') as Flag