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