Shell Programming and Scripting

i have two csv files (rates.csv, reference.csv) as below.

i have to cross check the Zone details in rates.csv with the reference.csv file for each row in rates.csv and make changes to Zone as per teh details present in reference.csv.
can someone plz provide a logic for this.

What you are trying to achieve with this two files ?
Can you please show us expected output.

Regards,

pamu

the rates.csv file should be like below after correction.

Code:

 
rates.csv
----------
23,38Nhava
45,37Newyork
89,Shilang
71,robacca

My intention is to modify the values in 2nd column in rates.csv file as per the details present in reference.csv as we are facing case sensitive issue in subsequent applications.
and as there are no of rows getting inserted each day in the rate.csv file, we want to setup a job to correct it.

You can use join for this, but you'll have to make sure that both files are sorted in the same way:

Code:

join -i -t"," -j1 2 -j2 1 -o 1.1,2.1 rates.csv reference.csv

In order to sort, you can use something like:

Code:

sort -f -t"," rates.csv
sort -f -k2 -t"," reference.csv

Code:

awk -F, 'NR==FNR{A[tolower($0)]=$0;next}{if(A[tolower($2)]){print $1 FS A[tolower($2)]}}' reference.csv rates.csv

That will fail everywhere except GNU-land. Just a warning in case the OP is not using Linux.

Regards,
Alister