Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| need some help..Comparison | bluesilo | Shell Programming and Scripting | 0 | 02-23-2008 04:43 PM |
| Comparison of 2 files in UNIX | Dana Evans | UNIX for Dummies Questions & Answers | 32 | 11-21-2007 07:05 AM |
| Comparison of two files in awk | jerome Sukumar | Shell Programming and Scripting | 12 | 07-26-2006 08:16 AM |
| String Comparison between two files using awk | rudoraj | Shell Programming and Scripting | 7 | 07-25-2006 11:04 AM |
| dir comparison help | ghazi | Shell Programming and Scripting | 5 | 12-20-2004 05:54 PM |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-04-2008
|
||||
|
||||
|
comparison of 2 files
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.. Last edited by kamal_418; 08-04-2008 at 05:20 AM.. |
|
08-04-2008
|
||||
|
||||
|
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. |
|
08-04-2008
|
|||||
|
|||||
|
You can use the join command (input files must be sorted on the first column) :
Code:
join kamal1.dat kamal2.dat Code:
111 222 333 888 Code:
000 1000 111 1111 222 1222 444 1444 777 1777 888 1888 999 1999 Code:
111 1111 222 1222 888 1888 |
| Sponsored Links | ||
|
|
Linear Mode
