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

 

x
Chapter Index
Next Topic:
Math Functions Syntax and Examples

 

String Function Syntax and Examples


This section provides the syntax for, and examples of, each NDL++ string function that can be used in ndlm data load specification scripts. For convenience, the functions are grouped according to the kind of operation they perform:
Data Generation Functions DATE()
GENKEY()
GENKEYCOL()
SPACE()
TIME()
Data Analysis Functions CMP()
INSTR()
INSTRREV()
ISENF()
ISNULL()
ISNUMERIC()
LEN()
Data Conversion Functions CONVERTDATE()
CONVERTTIME()

CONVERTTS()

ENFTONF()

LCASE()
NFTOENF()
STR()
STRENF()
UCASE()
VALENF()
VALENI()
VALF()
VALI()
Data Manipulation Functions

EXTRACTWORD()
LEFT()
LOOKUP()
LPAD()
LTRIM()
MID()
PAD()
REPLACE()
RIGHT()
RPAD()
RTRIM()
STRING()
STRREV()
TRIM()

The following considerations apply to the use of these functions:


European Number Format (ENF) functions

The NDL++ scripting language supports the European Number Format (ENF). A European number uses a comma ( , ) as the decimal delimiter, and a period ( . ) as the thousands separator. For example:

1.234,56

The ENF value above is equivalent to the Standard Number Format (NF) value 1234.56.

A European number may also have a +/– prefix and/or exponent value (scientific notation), such as:

+1,23456E+003

This value is also equivalent to 1234.56.

The following are the ENF functions:

 

x
Chapter Index
Next Topic:
Math Functions Syntax and Examples