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

Return to String Function Index

 

String Function Syntax and Examples

STRENF( )

The STRENF() function converts an int or float input value to an ENF string.

Syntax:

STRENF(input-number)

where:

input-number is an int or float value

Example:

input: 1234|187657.62

IMPORT @load.dat
{
    RECORD
    {
    field1 *|
    field2 *\r\n
    }
    public.table1
    {
    column1 STRENF( VALI(field1) )
    column2 STRENF( VALF(field2) )
    }
}

Results:

schema1.table1.column1	1.234
schema1.table1.column2	187.657,62

Note: In this example each column must be defined as CHAR or VARCHAR.

 

Return to String Function Index