Substring and Locate

Question

Hi

It is in OBIEE 12

I am using the substring and locate functions to find a specific word in a text field and it is fine but when that word I am looking for does not exist in the text, it is capturing the first word in the text...how can I have it so when that word I am looking for is not in the text then return blank?

Thanks

Joe

Joe Choueiri-Oracle · Answer

Thank you Christian, really appreciate it.

[Deleted User] · Answer

Yes that's exactly the way to write it.

Joe Choueiri-Oracle · Answer

I was going to try to use the substr and locate etc to find a specific word among a paragraph which I was able to do in OBIEE 12C but it seems it is not working for me in OAC DV..so I decided to write a case statement to say : case when "column that has a text" like '%##DIS%' THEN '##DIS' else '' end...will that work? it seems working, do you think I might face issues?