Shell Programming and Scripting

I want to duplicate a row if found two or more values in a particular column for corresponding row which is delimitted by comma.

Input

Code:

abc,line one,value1
abc,line two, value1, value2
abc,line three,value1

needs to converted to

Code:

abc,line one,value1
abc,line two, value1
abc,line two, value2
abc,line three,value1

How this could be done using unix script???

Thanks in advance..........

hello Incrediblian,
one thing I want to confirm is
"abc,line" will be constant or it may change.

Hi pradeep,

Thanks for your reply, No its not same, all the field would to be unique.
Input

abc, first line, value1
def, second line, value2,value3
ghi, third line, value4

need to be

abc, first line, value1
def, second line, value2
def, second line, value3
ghi, third line, value4


Thanks in advance....

Code:

perl -F, -lane'
if ( @F > 3 ) {
    print join ",", @F[ 0, 1, $_ ] for 2 .. @F - 1;
}
else {
    print;
}' infile

hi radoulov,

Thank you so much,

I am new to perl and unix as well. can you please explain me ?

Cant this be done using unix ?

Thanks in advance.

script is as below:
#! /bin/bash
while read line
do
first=`echo $line | awk -F "line" '{print $1}'
first=`echo $first line,`
value=`echo $line | awk -F "line" '{print $2}' | sed 's/,/ /g'`
for i in `echo $value`
do
echo $first $i
done
done < ref_file



Contents of ref_file is as below
abc, first line, value1
def, second line, value2,value3, value4
ghi, third line, value4 , value5

hello Incrediblian ,

This will work very well compared than previous one.

while read line
do
first=`echo $line | awk -F "," '{print $1}'`
second=`echo $line | awk -F "," '{print $2}'`
first_half=`echo $first,$second, `
value=`echo $line | cut -d "," -f 3- | sed 's/,/ /g'`
for i in `echo $value`
do
echo $first_half$i
done
done < ref


Contents of ref_file is as below:
abc,line first,value1
def,line second,value2,value3, value4
ghi,line third,value4, value2