DSXchange

Code: Select all

#!/usr/bin/ksh

#Change the following two lines
export inFile=/Data/SFDCDEV/temp/gsym.txt
export outFile=/Data/SFDCDEV/temp/Result_gsym.txt

#remove previous output file if exists.
if [ -f $outFile]
then
  rm -f $outFile
fi

#the main body
cat $inFile | while read line
do
  #The next 7 lines are referred as first part in my explanation below
   echo $line | awk 'BEGIN{FS="~"} 
                     {split ($5, c, ",")}
                     {
                      OFS="~"
                      for (z in c)
                      print $1,$2,$3,$4,c[z],$6,$7,$8,$9,$10,$11,$12
                     }' | while read A
 #The next 8 lines are referred as second part in my explanation below
 do
   echo $A |  awk 'BEGIN{FS="~"}
                   {split ($4, b, ",")}
                   {
                    OFS="~"
                    for (y in b)
                    print $1,$2,$3,b[y],$5,$6,$7,$8,$9,$10,$11,$12
                   }' | while read B
 #The next 8 lines are referred as third part in my explanation below  
 do
   echo $B |  awk 'BEGIN{FS="~"}
                   {split ($3, a, ",")}
                   {
                    OFS=","
                    for (x in a)
                    print $1,$2,a[x],$4,$5,$6,$7,$8,$9,$10,$11,$12
                   }' >> $outFile
  done
 done
done