I have the following CSV files:
File 1
19997,20161108,FSM,EXCHANGE_2,GLOBE,0
17541,20161108,TATA_MOBILE,WORLD,TELECOM,1
34556,20161108,europe,state,0
File 2
EXCHANGE_2,CANADA,30298
WORLD,INDIA,1123
state,canada,2241
How do I create a new file that combines the two by matching column 4 of file 1 with column 1 of file 2? The result should be:
19997,20161108,FSM,EXCHANGE_2,GLOBE,0,CANADA,30298
17541,20161108,TATA_MOBILE,WORLD,TELECOM,1,INDIA,1123
34556,20161108,europe,state,0,canada,2241