I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :

079661/3

I have to convert the above series as
079661
079662
079663
and store it as 3 different records.

Looking for help on how to achieve this. Am a newbie at Shell scripting.

Thanking all in advance for the help..

Mihir

echo '079661/3' | awk -F'/' '{for(i=0; i<$2; i++) print $1+i}'

echo '079661/3' | awk -F'/' '{for(i=0; i<$2; i++) print $1+i}'

79661
79662
79663

Since this is a phone number series, I don't want the 0's in the beginning to be ignored.

Thanks a lot for your response.

Mihir

echo '079661/3' | awk -F'/' '{for(i=0; i<$2; i++) { match($1, /^[^0]*/); print substr($1, 1, RSTART) substr($1, RSTART)+i}}'

Thanks....u've been a gr8 help...

a fix in regex:

echo '079661/3' | nawk -F'/' '{for(i=0; i<$2; i++) { match($1, "^[0]*[0]*[^0]"); print substr($1, RSTART, RLENGTH-1) substr($1, RSTART+RLEGTH)+i}}'

Try something like

while read line
do
#assuming the field is column X in each record with total N records
precolumns=`echo $line | cut -d',' f1,2,3,4,....X-1`
postcolumns=`echo $line | cut -d','  fX+1,X+2.....N`
echo $line | cut -d',' -fX | awk -F'/' '{for(i=0; i<$2; i++) print $precolumns "," $1+i  "," $postcolumns }' > $newfile
done < $filename