Splitting value list into single records

[mattso]

Thanks for any advice you can provide.

I have a table of tour operators and the parks they can operate in: TourOperator = text, Parks = ValueList. The result is each tour operator record has a multivalued list of parks separated by carriage returns .

TourOperator1 ...... Park1Park2Park3

TourOperator2 ...... Park1Park2

I need to find a way to split the multivalued list into single records:

TourOperator1 ...... Park1

TourOperator1 ...... Park2

TourOperator1 ...... Park3

TourOperator2 ...... Park1

TourOperator2 ...... Park2

It doesn't seem too difficult at first glance, and I've made minor progress with a customised script, but after searching these forums I couldn't find any solutions so I'd appreciate any help.

Thanks :

[mr_vodka]

You will need to write a script to loop through the records and parse out the info. This was a quick and dirty loop. Not really elegant but should do the job.

tour.zip

[mattso]

Fantastic! Thanks Mr Vodka you've just saved us a lot of time and heartache. I adopted your script to my tables and it worked fine :)