PowerCenter
- PowerCenter 10.5
- All Products
INDEXOF(valueToSearch, string1 [,string2, ...,stringN,] [CaseFlag])
Argument
| Required/
Optional
| Description
|
---|---|---|
valueToSearch
| Required
| String datatype. Value you want to search for in the list of strings.
|
string
| Required
| String 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 CaseFlag to 0.
|
CaseFlag
| Optional
| Must be an integer. Specify a value when the valueToSearch argument is a string value. 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 0, the function is not case sensitive.
|
INDEXOF( ITEM_NAME, ‘diving hood’, ‘flashlight’, ‘safety knife’)
|
|
---|---|
|
|
|
|
|
|
|
|
|
|