topic Re: Checking for Integer in Qlik Automate

Checking for Integer

ProfPhidd — Fri, 20 Oct 2023 11:56:52 GMT

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.

MatheusC — Fri, 20 Oct 2023 13:50:26 GMT

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 — Fri, 20 Oct 2023 14:03:37 GMT

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