Return to String Function Index
String Function Syntax and Examples
The VALENI() function converts a valid ENF string to an int value. The input value must be an ENF integer, otherwise an error will be returned.
Syntax:
VALENI(input-string)
where:
input-string is a valid ENF string
Example:input: 27.657
IMPORT @load.dat
{
RECORD
{
field1 *\r\n
}
public.table2
{
column1 VALENI(field1)
}
}
Results:
schema1.table2.column1 27657 Note: In this example the column must be defined as INTEGER or SMALLINT.
Return to String Function Index