Shell Programming and Scripting

Kindly help on follows.

I have 2 files. One file contains only one column of mobile numbers. And total records in a file 12 million. Second file contains 2 columns mobile numbers and balance. and total records 30 million. I want to find out balance of each data in file 1 corresponding to file 2. I tried egrep -f but it will take very long time. And also use awk '{OFS="|"}NR<=FNR{a[$1]=$1}NR>FNR{print $1,$2,a[$1]}' a b but its given error after 7 million says long data. Can you provide me other commands. please

Thanks in advance..

For that amount of data, maybe it would make sense to import the information into a database.

Search this site for NR=FNR for a number of awk solutions to similar problems.

You can use the join command (input files must be sorted on the first column) :

Code:

join kamal1.dat kamal2.dat

Input file 1 (kamal1.dat) :

Code:

111
222
333
888

Input file 2 (kamal2.dat) :

Code:

000 1000
111 1111
222 1222
444 1444
777 1777
888 1888
999 1999

Output :

Code:

111 1111
222 1222
888 1888

Jean-Pierre.