@ISNUMERIC

Determine if a text string can be converted to a numeric value.

Syntax

@ISNUMERIC(t1)

Argument	Description
t1	A string that is potentially a number.

Logic

This function will determine if a string is in fact a number, returning 1 if true and 0 if false. It will work with decimal and negative numbers and can be used in an @IF function.

Examples

@ISNUMERIC("abc") returns 0

@ISNUMERIC("12") returns 1

@ISNUMERIC("-34.34" ) returns 1

@ISNUMERIC("36b" ) returns 0

@IF(@ISNUMERIC(@LEFT("{name1}", 4)), @LEFT("{name1}", 4), "0000")