How to extract the last word in a sentence string in OBIEE ?

Question

Lets say i have a character string, "This is a good day" and i need to extract the last word of the string and convert it to something else.

How can i do that using OBIEE functions ?

GermanA-Oracle · Answer

Here are the string functions Expression Editor Reference for version 12.2.1.3.0.

Rohit Trehan · Answer

Hi Christian,

Let me try it OBIEE and if it works, will mark your answer as correct.

Also need to find the corresponding string functions in OBIEE.

Thanks

Rohit

[Deleted User] · Answer

Funny enough google has two similar answers as first hits and both work in Excel as well as OBI with the usual string manipulation functions:

How to extract the last word in a cell in Excel

https://exceljet.net/formula/get-last-word