6 Replies Latest reply on Jan 22, 2013 9:22 AM by sinadashtipour

    Extracting Multiple Substrings

    sinadashtipour

      Hi, please see the list of strings below in CS_Query:

       

      I need to extract some strings from the Dimension CS_Query into different separate Dimensions.

       

      CS_Query
      ReportingService=ZZABC&Frequency=M&Currency=GBP&Culture=en-GB&FileFormat=pdf&ReportingPeriod=2011M12&
      ReportingService=ZZDABS&Frequency=Q&Currency=GBP&Culture=en-GB&FileFormat=pdf&ReportingPeriod=2011Q12&
      ReportingService=ZZDABS&Frequency=Q&Currency=GBP&Culture=en-GB&FileFormat=pdf&ReportingPeriod=2011Q12&
      ReportingService=YYABC&Frequency=A&Currency=DKK&Culture=da-DK&FileFormat=pdf&ReportingPeriod=2010A12&
      ReportingService=ZZABC&Frequency=M&Currency=GBP&Culture=en-GB&FileFormat=pdf&ReportingPeriod=2011M12&
      It should be split into the three dimensions as below:
      ReportingServicesFrequencyReportingPeriod
      ZZABCM2011M12
      ZZDABSQ2011Q12
      etc..
      etc..

       

      Would be grateful for any ideas.

       

      Many thanks!