Forum Moderators: coopster
I have a csv file and wish to split out seperate years for each line.
For example:
widget A,1966-2003,$6.00
is a single entry (of many).
What I want to do is split ($row[1]) into
widget A 1966 $6.00
widget A 1967 $6.00
widget A 1968 $6.00
.....
widget a 2003 $6.00
I just can't find the needed function to do this.
I believe I could split the years out into 1966 and 2003 and do a count or a range function, but is there any easier way?
Any ideas?