Return to String Function Index
String Function Syntax and Examples
ISNUMERIC( )The ISNUMERIC() function determines whether the specified field is composed of numeric characters. If the input value is an integer, the function returns 1; if the input value is a float, the function returns 2. If the field contains any non-numeric characters, apart from an appropriately placed plus sign (+), negative sign (-), period (.), 'E', or 'e', the function returns 0.
Syntax:
ISNUMERIC(field-label)
Example:input: 2899965
IMPORT @sample.dat
{RECORD
{
field1 *\r\n
}
schema1.table1
{
col1 ISNUMERIC(field1)
}}
Results:
schema1.table1.col1 1
Return to String Function Index