IndexOf - Index of value in a list of values in Informatica

IndexOf function returns index of the item in value list i.e if it matches at first value in the list it returns 1 and so on. If no match is found the function returns 0. By default the function is case sensitive.
INDEXOF( valueToSearch, string1, [string2, ..., stringN,] CaseFlag )

ArgumentRequired/OptionalDescription
valueToSearchRequiredString datatype. Value you want to search for in the list of strings.
stringRequiredString datatype. Comma-separated list of values you want to search against.Values can be in string format. There is no maximum number of values you can list. The value is case sensitive, unless you set MatchCase to 0.
CaseFlagRequiredMust be an integer. Determines whether the arguments in this function are case sensitive. You can enter any valid transformation expression. When CaseFlag is a number other than 0, the function is case sensitive. When CaseFlag is a null value or 0, the function is not case sensitive.

Example :
INDEXOF( ITEM_NAME, ‘diving hood’, ‘flashlight’, ‘safety knife’)

ITEM_NAMERETURN VALUE
Safety Knife0
diving hood1
Compass0
safety knife3
flashlight2