Shell Programming and Scripting

hi,

i have 1 files a.csv temp.out

a.cvs looks like

Code:

add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-209
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-219
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-220
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-221

and temp.out looks like

Code:

902,497,902,209,1003,1003,HALIFAX NS
902,497,902,219,1003,1003,HALIFAX NS
902,497,902,220,1003,1003,HALIFAX NS
902,497,902,221,1003,1003,HALIFAX NS

if 6,7,8,9 th filed of a.csv matches with 1,2,3,4 of temp.out then output should looks like

Code:

add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-219,1003,1003,HALIFAX NS
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-220,1003,1003,HALIFAX NS
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902-221,1003,1003,HALIFAX NS

i am working with awk script but is unable to compare the four fileds ?

---------- Post updated at 04:04 AM ---------- Previous update was at 04:02 AM ----------

i am sorry output shold olooks like as below(that was mistake)
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,219,1003,1003,HALIFAX NS
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,220,1003,1003,HALIFAX NS
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,221,1003,1003,HALIFAX NS

---------- Post updated at 04:06 AM ---------- Previous update was at 04:04 AM ----------

sorry a.csv file looks like as below

add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,209
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,219
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,220
add,16390,180,674X,HALIFAX_COMMONS_X,902,497,902,221


both input and output are comma seperated

Try this:

Code:

awk -F, 'NR==FNR{a[$6$7$8$9]=$0;next}
a[$1$2$3$4]{print a[$1$2$3$4], $5, $6, $7}
' OFS="," a.csv temp.out

Use nawk or /usr/xpg4/bin/awk on Solaris if you get errors.