index_of function

The index_of function determines the position of the first character of the search string at its first occurrence if any.

returnvalue index_of(source, search_string [, start_position])

source ::= any*
search_string ::= any*
start_position ::= integer*
returnvalue ::= integer

Various return values:

• Returns the position of the first character of the search string at its first occurrence. The position is relative to the start position of the string (which is zero).

• Returns -1 if search_string is not present in the source.

• Returns 0 for any value of source if the search_string is of length 0.

• Returns NULL if any argument is NULL.

• Returns NULL if any argument is an empty sequence or a sequence with more than one item.

• Returns error if start_position argument is not an integer.

Example 1 - Determine at which position “-“ is found in the estimated arrival time of the first leg for the passenger with ticket number 1762320569757.

SELECT index_of(bag.baginfo.flightLegs[0].estimatedArrival,"-")
FROM BaggageInfo bag
WHERE ticketNo=1762320569757

Output:

{"Column_1":4}

Example 2 - Determine at which position “/” is found in the routing of the first leg for passenger with ticket number 1762320569757. This will help you determine how many characters are there for the source point for the passenger with ticket number 1762320569757.

SELECT index_of(bag.baginfo.routing,"/")
FROM BaggageInfo bag
WHERE ticketNo=1762320569757

Output:

"Column_1":3}