2 Replies Latest reply on Feb 19, 2016 5:19 PM by Thomas Dodds

    How do you find a string within another string (complex)

    Jerry S.

      OBIEE 11g.

       

      We have a name field that consists of first and middle initial (if one exists), followed by the last name.

      each initial, if it exists, is followed by a period, hyphen, underscore, slash, or space.

       

      Here are some of the possible entries:

      J.D.Doe

      J.Doe

      Doe

      J_D_Doe

      J.D_Doe

      J_D.Doe

      J Doe

      J/Doe

       

      As you can see, the only real constant here, is the last name occupies the n rightmost columns of the field.

       

      I'm trying to extract the last name, but just dont know how to write the SQL to do it.

      This needs to be done in the "Edit Formula" area in an analysis.

       

      Is it even possible to do this inside an analysis?