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


Return to String Function Index

 

String Function Syntax and Examples


INSTRREV( )

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

Syntax:

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

where:

Example:

input: thisISasamplestring

IMPORT @sample.dat
{

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

}


Results:

schema1.table1.col1 4
schema1.table1.col2

 

Return to String Function Index