1 Reply Latest reply on Aug 6, 2015 3:46 AM by user13816768

    OBIEE 11g Substring upto space

    user13816768

      Hi All -

       

      Can you please help me in getting a substring function in obiee 11g logical layer ?

       

      For example:

       

      ABC 2.0

      EFGH 9.0

      WE 12.0

       

      we would like to print only the values upto first space.  i.e., we would like to see only

       

      ABC

      EFGH

      WE

       

      Trying substring and length but not working.

       

      Thanks!