Connect CDC SQData

The SEARCH function examines a source data string and compares it against a second search data string. If the search data string is found within the source data string,  Connect CDC SQData returns the starting position of the matching characters within the source data string. If no match is found, a value of zero (0) is returned.

Category

String

Syntax

SEARCH(data_string, search_data_string)

 

Parameter Descriptions

data_string  The source data string in character format. The data string can be a field from a source datastore, a variable, a constant or the result of another Function.

search_data_string One (1) or more characters that will be used as the search criteria to examine the data string for a match. Search data strings may be a field/column of a datastore, a literal value or the output of another Function.

Example

Find the position of the value TAN within a source field INPUT_STRING. Assume that the field INPUT_STRING contains the value MUSTANG. Map the result to target field STRING_POS.

STRING_POS = SEARCH (INPUT_STRING,  'TAN')

Returns the value 4 and maps the result to the target field.

 

Search a literal for the value RED and return the position in which the match first occurs. Map the result to target field STRING_POS.

STRING_POS = SEARCH ('READY', 'RED')

Returns the value 0, since there source data string did not contain the value 'RED'.