2 Replies Latest reply on Nov 5, 2013 7:36 AM by yulia.khazanova

    Split text  & create new dimensions

    yulia.khazanova

      Hello Everyone!

       

      Could you please help me to split text and create new dimensions out of it. Please find attached the file  "TEST text" with the example.

       

      Out of these texts I need to make sure that I create 2 dimensions:

      1). BOOKING (should include the part of the text where you see "aaaa...", but of course in real, it is just combination of letters and numbers)

      2). FLIGHT DETAILS  (which is covering the part with "ccccc". )

       

      So, the idea is the following:

      • always the first part of the text is BOOKING (excluding "/" and "?" or "/")
      • If we have "/........?......." then keep the part between  "/" and "?" and make it part of BOOKING dimension, we don't need anything after "?"
      • if we have "/......./......." then keep the part between  "/" and "/" and make it part of BOOKING dimension, we don't need anything after "?"
      • if we have "/......./Flight/Details/....." then keep the parts between  "/" and "/" and make the fist part a BOOKING dimension, and the last part "FLIGHT DETAILS". We don't need "/Flight/Details/" part.

       

      So, I would expect the following result at the end (please see "TEST text RESULT").

      Hope you will be able to help me.

       

      Thank you!

      Yulia