How to extract the last word in a String in OBIEE ?

[Ray]

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 ?

[Christian Berg]

I already answered that question on OTN yesterday.

On 22 Sep 2017 5:02 pm, "Ray" <seek...@gmail.com> wrote:

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 ?

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterprise-methodology@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en

All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/).  Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[paresh bhangale]

use left & right function

On Fri, Sep 22, 2017 at 5:53 PM, Ray <seek...@gmail.com> wrote:

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 ?