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

Return to String Function Index

 

String Function Syntax and Examples

VALENF( )

The VALENF() function converts a valid ENF string to a float value. The input value must be an ENF number, otherwise an error will be returned.

Syntax:

VALENF(input-string)

where:

input-string is a valid ENF string

Example:

input: 187.657,62|1.234

IMPORT @load.dat
{
    RECORD
    {
    field1 *|
    field2 *\r\n
    }
    public.table3
    {
    column1 VALENF(field1)
    column2 VALENF(field2)
    }
}

Results:

schema1.table3.column1	1.87657620000000e+05
schema1.table3.column2	1.23400000000000e+03

Note: In this example the columns must be defined as FLOAT, REAL, or DOUBLE PRECISION.

 

Return to String Function Index