SAND CDBMS Tools Reference Guide
NDL++ Functions:
Syntax and Examples


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