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


Return to String Function Index

 

String Function Syntax and Examples


VALENI( )

The VALENI() function converts a valid ENF string to an int value. The input value must be an ENF integer, otherwise an error will be returned.

Syntax:

VALENI(input-string)

where:

input-string is a valid ENF string


Example:

input: 27.657


IMPORT @load.dat
{
    RECORD
    {
    field1 *\r\n
    }
    public.table2
    {
    column1 VALENI(field1)
    }
}


Results:

schema1.table2.column1 27657

Note: In this example the column must be defined as INTEGER or SMALLINT.

 

Return to String Function Index