The TextToDecimalValidate function is a built-in function that returns true if Text t can be converted to a Decimal value.

You can use this function before converting the Text value to the Decimal value with the TextToDecimal function.

Input parameters

t: Text Type

Output parameters

Boolean Type

Examples

Usage

Result

TextToDecimalValidate( "200" )

True

TextToDecimalValidate( "-200" )

True

TextToDecimalValidate( "200.482" )

True

TextToDecimalValidate( "-200.482" )

True

TextToDecimalValidate( "0.99999999" )

True

TextToDecimalValidate( "abc" )

False

See Also

TextToDecimal Function | Available Conversion Functions to Decimal | Available Built-in Functions