posted 11 years ago
Hi,
I have two files in unix. First file has only loan number and second file has lender number and loan number. I wanted to compare both loan numbers and update lender number with 909090. How do I do that.
Sample First File: First.txt
Loan Number
123456
333333
555555
888888
999999
Sample Second File: Second.txt
Lender Number,Loan Number
345900,123456
567209,888888
780909,345465
After executing the script output in Second.txt should be
Lender Number,Loan Number
909090,123456
909090,888888
780909,345465 ---> No change her, because loan number does not match from both the files.
Your help is grealy appreciated.