Need to check the number format

Xpert · Post by **Xpert** » Wed Apr 29, 2009 11:13 pm

Hi,

I am getting numeric values in a column. It contains both kind of numeric values i.e. 123 and 123.45

Now I need to check whether the incoming value is whole value(123) or floating value(123.45).

Could anyone help me how to check the value?

Thanks in Advance

Kryt0n · Post by **Kryt0n** » Wed Apr 29, 2009 11:37 pm

Does 123.00 count as a whole value of floating point?

Scan for decimal point?
<value> mod 1 > 0?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 30, 2009 12:31 am

Index(InLink.TheString, ".", 1) will return 0 if there is no "." and a positive number if there is.
(InLink.TheString Matches "1N0N" : @VM : "1N0N'.'0N") will test for unsigned numeric formats.