Return to String Function Index
String Function Syntax and Examples
ISENF( )The ISENF() function checks if the input string is a valid European number. If the input string is an ENF, the value 1 is returned; otherwise 0 is returned.
Syntax:
ISENF(input-string)
where:
input-string is a character string value
Example:
input: 1.234,01|1234|1.234
IMPORT @sample.dat
{RECORD
{
field1 *|
field2 *|
field3 *\r\n
}
schema1.table1
{
col1 ISENF(field1)
col2 ISENF(field2)
col3 ISENF(field3)
}}
Results:
schema1.table1.col1 1 schema1.table1.col2 0 schema1.table1.col3 1 Note: Each column must be defined with a data type/domain capable of storing numbers. Also note that the ISENF function returns 1 (true) for the third input value in the example (1.234), although this value can be interpreted as either an ENF positive integer or an NF decimal value.
Return to String Function Index