1 Reply Latest reply: Apr 21, 2013 9:53 PM by Arul RSS

    Using Javascript to manipulate strings in columns of OBIEE Answers

    Arul
      Hi Experts,

      I am using OBIEE 11g. I have to perform a complex string manipulation. Pls find the sample manipulation:

      Input Column String:

      Sample1: AB_ONE_12345678:67676767:12345123,AB_TWO_SECONDSTRING,AB_THIRD_FINALSTRING
      Sample2: AB_ONE_12345678:67676767,AB_TWO_SECONDSTRING,AB_THIRD_FINALSTRING
      Sample3: AB_ONE_12345678,AB_TWO_SECONDSTRING,AB_THIRD_FINALSTRING

      From the above string, I need to create three dummy columns as below:

      Column 1
      Sample1- www.google.com/search?q=12345678,https://www.google.com/search?q=67676767,https://www.google.com/search?q=12345123 (Initally I have to split the numbers after AB_ONE_ based on ":" )
      Sample2- www.google.com/search?q=12345678,https://www.google.com/search?q=67676767
      Sample3- www.google.com/search?q=12345678

      Column 2 - SECONDSTRING (String which comes after AB_TWO_ till ',')
      Column 3 - AB_THIRD_FINALSTRING

      Could you pls help?

      Which is the best way to meet my requirement?

      If JavaScript is the solution, could you pls suggest how to implement?

      Thanks,
      Arul