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

Return to String Function Index

 

String Function Syntax and Examples

TRIM( )

The TRIM() function removes all instances of the specified character from both the left and right sides of the specified string. If more than one character is specified for the char argument, only the first is used.

Syntax:

TRIM(string,char)

where char is the character to be removed.

Example:

input: XsamplestringX

IMPORT @sample.dat
{

RECORD
{
field1 *\r\n
}
schema1.table1
{
col1 TRIM(field1,'X')
}

}

Results:

schema1.table1.col1

samplestring

 

Return to String Function Index