How do I check for an integer

[Sentra_Ventures]

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

[Jonathan_S]

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)

help.appsheet.com

EXTRACT()

Extract values from text.

help.appsheet.com

LEN()

Number of characters in textual value

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.

[Sentra_Ventures]

hey thanks. i’ll give it a go

[Bahbus]

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)