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


Return to String Function Index

 

String Function Syntax and Examples


INSTR( )

The INSTR() function returns an integer indicating the position of the first character of the first occurrence of a given string within another string.

Syntax:

INSTR(string1,string2[,[CASEINSENS | 0] | [CASESENS | 1] ])

 where:


Example:

input: THISisasamplestring

IMPORT @sample.dat
{

RECORD
{
field1 *\r\n
}
schema1.table1
{
col1 INSTR(field1,'is')
col2 INSTR(field1,'is',0)
}

}


Results:

schema1.table1.col1 5
schema1.table1.col2

 

Return to String Function Index