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


Return to String Function Index

 

String Function Syntax and Examples


VALF( )

The VALF() function converts a string to a numeric float value. The record is rejected if any non-numeric characters are found in the string other than a single decimal point (.), and scientific notation up to 3 positions after the e and any sign that follows it.

Syntax:

VALF(string)


Example:

input: 555.3477


IMPORT @sample.dat
{

RECORD
{
field1 *\r\n
}
schema1.table1
{
col1 (field1)
col2 VALF(field1)

}


Results:

schema1.table1.col1 '555.3477'
schema1.table1.col2 5.5534770E+002 column declared as float(24)

 

Return to String Function Index