How do I check for an integer

Hi, Whats a quick way to check if the result of a comparison is an integer? Thanks

0 3 630
3 REPLIES 3

Im not sure but quickly off the top off my head, you could extract numbers and than see if the string length is the same. LEN ( text -expression)

Problem is extract numbers will also extract three from "I am three years old " and will return it as 3.
Not sure if there are some variables you can set so it only extracts Integers.

But the length comparison should take care of that anyhow.

hey thanks. iโ€™ll give it a go

Bahbus
New Member

Any number of ways to check depending on where you are doing it. For example, Number columns can only hold integers.

FLOOR(expression)=CEILING(expression)
NUMBER(expression)=DECIMAL(expression)

Top Labels in this Space