This content has been marked as final. Show 3 replies
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
|01008||01009||853-||853-||Materials and consumables|
|01008||01009||901-||928-||Materials and consumables|
|01008||01009||931-||944-||Materials and consumables|
|01008||01009||905-||913-09||Materials and consumables|
|01008||01009||957-||957-||Materials and consumables|
|01008||01009||963-||981-||Materials and consumables|
|01012||01012||853-||853-||Materials and consumables|
|01012||01012||901-||928-||Materials and consumables|
So what i want to do is get all variations of CC From - CCTo in one field rather than 2.
the first line is 01051 01061, so in the new field i would have the following..
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.
905 to 913-09 , i would need a table containing
Can anyone help please? .