DSXchange

I have to give a constraint which compare for a string pattern "product" in the description and reject the record..........
Is there any method to do it.
i have tried the compare function.its not workin.
I need to search the word product in the whole description any if it is present anywhere then reject the record.

Thanks,
Jayant

Hello there Jayant,

you can use the INDEX function in PX, the syntax is the same as that for a server job, INDEX(BigString,SearchString,Occurence) -> i.e. INDEX('This is a long string with Product numbers in it','Product',1) will return 28 and it will return a 0 when the SearchString does not occur in the BigString.

Jayant,

U can use INDEX function.
Syntax for Index function is Index (string, substring, instance).
This function will return the starting position of the sub string.
If substring is an empty string, 1 is returned. If substring is a null value, 0 is returned.

Thanks a lot guys the thing is working absolutely fine now.......

You may like to convert both the search string and the main string to upper case, in order to perform a case-insensitive search.