Find a String inside another string in BODS /SAP Data services

[malinisomu]

Hi ,

I need to search a string value inside another string and if its exist i have to have a column with the value 'YES' or 'No'

in the below example I have to search UNSPSC_DESCRIPTION1 in COMMPODITY ASSIGNMENTS

Since there is no built in functions available.If anyone come up with some custom function that would be great help for me.

Thanks,

Malini

[former_member1291121]

On a Query transform use ifthenelse(substr(COMMPODITY ASSIGNMENTS, UNSPSC_DESCRIPTION1,len(COMMPODITY ASSIGNMENTS) is null, 'NO','YES')

[malinisomu]

joseph_muiruri Thank you very much for your elaborate answer. It works.

Thanks,

Malini