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

Return to String Function Index

 

String Function Syntax and Examples

SPACE( )

The SPACE() function returns a string consisting of the specified number of space characters.

Syntax:

SPACE(n)

where:

n sets the number of spaces to insert. Specifying 0 will return an "empty string" (length=0).

Example:

input: 1,samplestring

IMPORT @sample.dat
{

RECORD
{
field1 *,
field2 *\r\n
}
schema1.table1
{
col1 LEFT(field2,6)+SPACE(INT(field1))+MID(field2,7)
}

}

Results:

schema1.table1.col1

sample string

 

Return to String Function Index