Shell Programming and Scripting

10,dravid,10000,5000,abc
20,sachine,20000,10000,bbc
30,raina,4000,1200,ccb

10,dravid,10000,5000,abc,900010,1234
20,sachine,20000,10000,bbc,900010,1234
30,raina,4000,1200,ccb,900010,1234

#!/bin/sh

#################################################################
# adding columns to file.
#################################################################

for file3 in `ls|grep Detail| grep csv`
do


########Fetching SiteID information example: 1234############
########Fetching PID information example: 900010############
########Filename example: customer_information_detail_900010_1234############

       SiteID=`echo $file3 |cut -d "." -f1 |awk -F[_-] '{print $(NF)}'`
       PID=`echo $file3 |cut -d "." -f1 |awk -F[_-] '{print $(NF-1)}'`
       filename=`echo $file3 |cut -d "." -f1`


       awk 'BEGIN {FS=OFS=","} {print $0,FILENAME,FILENAME}' $file3 > $filename".txt"
       sed s/$file3/$SiteID/g  $filename".txt" >temp.txt
       sed s/$file3/$PID/g  temp.txt >$file3
done

[house@leonov] cat data.file
10,dravid,10000,5000,abc
20,sachine,20000,10000,bbc
30,raina,4000,1200,ccb
[house@leonov] V1='this'; V2='that'; sed -i data.file -e "s/^.*$/&,$V1,$V2/g"
[house@leonov] cat data.file
10,dravid,10000,5000,abc,this,that
20,sachine,20000,10000,bbc,this,that
30,raina,4000,1200,ccb,this,that