Checking for Integer

[ProfPhidd]

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

[MatheusC]

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')

[maheshkuttappa · Accepted solution]

Isnum(left('1234BE3',1)), results - Numeric value "-1"  and non-numeric value "0".