Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community, I am still new to Qlik. How do i check to see if the first character is an integer. e.g. I have a product ID 1234BE3
Thanks.
AP
Isnum(left('1234BE3',1)), results - Numeric value "-1" and non-numeric value "0".
Hi, @ProfPhidd
Leave a suggestion
There may be other better solutions, this is a path I found.
see if it helps
flag
if(Left(field,'1') >=0
and
Left(field,'1') <=9,
'int','not int')
Isnum(left('1234BE3',1)), results - Numeric value "-1" and non-numeric value "0".