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

Return to String Function Index

 

String Function Syntax and Examples

ENFTONF( )

The ENFTONF() function returns an NF string if the input is a valid ENF string. If the input is not a valid ENF string, it returns the input string unchanged.

Syntax:

ENFTONF(input-string)

where:

input-string is a character string value

Example:

input: 8.888,01

IMPORT @sample.dat
{
    RECORD
    {
    field1 *\r\n
    }
    schema1.table1
    {
    column1 VALF( ENFTONF(field1) )
    }
}

Results:

schema1.table1.column1

8888.01

Note: In this example column1 must be defined as DECIMAL or FLOAT.

 

Return to String Function Index