Shell Programming and Scripting

Can someone please help me to write script for following scenario :

1> script should read a input .csv file of format : EmpName, PF, Leave, Basic ,HRA
2> another config file ( may be again a .csv file ) has format EmpName and EmpID
3> script should read another config file for each EmpName in the input file , to find the EmpID
4> After finding EmpID from config file, all records need to be written in 3rd file ( output file ) with format : EmpName ,EmpID ,PF, Leave ,Basic ,HRA

Thanks

Here's something to start with.

nawk -F',' -v OFS=':' -f emp.awk conf.csv input.csv

emp.awk:

Code:

NR==FNR { a[$1] = $2; next }
$1 in a { $1=$1 OFS a[$1]; print}

Hi,

input:

Code:

a:
leo pf1 leave1 basic1 hra1
james pf2 leave2 basic2 hra2
tony pf3 leave3 basic3 hra3
b:
leo 210375
james 210075
tony 210378

output:

Code:

leo 210375 pf1 leave1 basic1 hra1
james 210075 pf2 leave2 basic2 hra2
tony 210378 pf3 leave3 basic3 hra3

code:

Code:

awk '
{
if (NF==2)
id[$1]=$2
else
print $1,id[$1],$2,$3,$4,$5
}' b a

Thanks for your replies ....

I'm unaware of awk programming .... can you please explain me the logic used here ??

Many Thanks