IsInteger and leading Zeros

kevind0718

Hello:

I have a hard time believing what I am seeing here.

I am using IsInteger to determine if a string is an integer (is a zip code).

What I found is that IsInteger gets confused by leading zeroes.

Attached is simple workflow.

Here are my results

Field1 Check
20220228 True
20200331 True
20270220 True
20161001 True
00112233 False
001234 False
010101 False

What am I missing here.

Best Regards

testIsInteger.yxmd

Workflow

Accepted answers

Deano478

@kevind0718 no its not a bug it is the way Alteryx interprets the values this stems from most programming languages as leading zero's can imply different number representation/formats such as octal or hexadecimal to name a few depending on the context hence why alteryx is most likely treating the leading zero's as text to avoid these types of issues and for simplicity purposes.

All comments

aatalai

@kevind0718 check this workflow

testIsInteger.yxmd

kevind0718

add some text strings to the Text Input you then get

Field1 Check
20220228 True
20200331 True
20270220 True
20161001 True
00112233 True
001234 True
010101 True
ABC True
ALTERYX True

plus some warnings

The issue is: we have a string want to check if that string contains only digits (0 -9)

And there could be leading zeros

RaphaelSilva

Not exactly a bug, leading zeros are useless, numerically speaking, so if that contains a leading zero it is not an integer, it is a string.
In the same way a ZIP code is not a integer per say, it is a string with numbers.

mwoods1

Hi, a bit late to the party with this one but you can combine the trimleft() function to get what OP is after without using regex:

IsInteger(TrimLeft([Field],"0"))

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703