3 Replies Latest reply: May 18, 2012 9:58 AM by Jason Michaelides RSS

    loop through data to get all variations.

    Chris Hopkins

      Hi everyone.

      I need help with writing a script to read through my data and generate a new table for all variations .

       

      Here is a sample of how the data looks

       

      CC From      CC To             EC From       EC To                 Description

      0105101061854-890-Servicemen
      0120501205850-852-Servicemen
      0120501205854-890-Servicemen
      0100801009853-853-Materials and consumables
      0100801009901-928-Materials and consumables
      0100801009931-944-Materials and consumables
      0100801009905-913-09Materials and consumables
      0100801009957-957-Materials and consumables
      0100801009963-981-Materials and consumables
      0101201012853-853-Materials and consumables
      0101201012901-928-Materials and consumables

       

      So what i want to do is get all variations of CC From - CCTo in one field rather than 2.

      eg

      the first line is 01051 01061, so in the new field i would have the following..

       

      01051

      01052

      01053

      01054

      01055

      01056

      01057

      01058

      01059

      01060

      01061

      Then loop through again to do line 2 etc etc

      I need all of the relationships still to be there too, so when 01053 is selected, i still want to see EC details from 854-890 and for servicemen.

       

      I want to do the same for ECFrom and ECTo but these fields contain additional characters.

       

      Eg

      905 to 913-09 , i would need a table containing

       

      905

      906

      907

      908

      909

      910

      911

      912

      913-00

      913-01

      913-02

      913-03

      913-04

      913-05

      913-06

      913-07

      913-08

      913-09

       

      Can anyone help please? .