I have 2 files namely branch.txt file & RXD.txt file as below
Ex:Branch.txt
B1,Branchname1,city,country
B2,Branchname2,city,country
B3,Branchname3,city,country
B4,Branchname4,city,country
B5,Branchname5,city,country
RXD file : will contain old branch code, old accountid, new branch code and new Accountid.
RXD.txt
B1,B1A1,WB1,WB1A1
B1,B1A2,WB1,WB1A2
B2,B2A1,WB2,WB2A1
B2,B2A2,WB2,WB2A2
B3,B3A1,WB3,WB3A1
B1,B3A2,WB3,WB3A2
We need to compare old branch codes in the abv 2 files and create a new newBranchfilter.txt with new branch code (Similar to oracle equi join)
newBranchfilter.txt
WB1,Branchname1,city,country
WB2,Branchname2,city,country
WB3,Branchname3,city,country
Im new to Unix shell scripting..can anyone help me to solve this using unix shell script.
Thank you!