Hello there,
I'd like some guidance into how I could do the following:
I have such a file:
red,07,car
red,08,plane
red,09,submarine
blue,03,car
blue,04,plane
blue,05,submarine
green,05,car
green,06,plane
green,07,submarine
I'd need to transform it to the following:
red,01,nothing
red,02,nothing
red,03,nothing
red,04,nothing
red,05,nothing
red,06,nothing
red,07,car
red,08,plane
red,09,submarine
blue,01,nothing
blue,02,nothing
blue,03,car
blue,04,plane
blue,05,submarine
green,01,nothing
green,02,nothing
green,03,nothing
green,04,nothing
green,05,car
green,06,plane
green,07,submarine
Basically auto-complete so the lines start at 01 for every 'color' line

Well I got it working :)
I created a template file and then looped line by one and compared line[x] to template[x] to see if there was a match and inserted the data.

Well I got it working :)
I created a template file and then looped line by one and compared line[x] to template[x] to see if there was a match and inserted the data.
Sorry, i don't entirely understand what it is you are trying to do. :)
Lawrence