hi
I have 2 files to comapre ,in file a sible column it is numbers,in file b2 numbers and other values with coma separated.
i want compare numbers in file a with file b,and the out put put should be in C with numbers in both file a and b along with other columns of file b.
i used folowing scripts
for line in `cat gprs2.txt`
do
more gprs_calls2.txt |grep $line >> NEW2.txt
done
exit
but it is not giving correct out put.and also this scrpits is not sppedy
plz help..
start with something like this:
grep -f gprs2.txt gprs_calls2.txt > NEW2.txt
I had trouble understanding what you need. This just prints what is in file gprs_calls2.txt. Not what is in both files
The files are like this
File1
12345
56789
23456
File2
12345 fsfsdf 76775
23456 ytyy 090890
66444 rytry 878878
The out put should be
12345 fsfsdf 76775
23456 ytyy 090890
The file1 contains arround 1 million lines file2 has 2.5 million lines
pls help..
The standard solution will hold the entire file1 in memory:
awk>file3 'NR==FNR{_[$1];next}$1 in _' file1 file2
I have Tried .could u plz help..
out 'NR==FNR{_[$1];next}$1 in _' gprs2.txt gprs_calls2.txt
scripts by rplacing the respective filenames ,the out put does not have any data
the actual file lokks like this
Source file
7055000601
7055000633
7055000965
7055001182
7055001352
7055001468
Dest file to be compared(Source file no should be compared with dest file,the out should be the no of desti ,which exists in source,along with othere columns of desti corresponds the number
7055000601,35250401506992,621505200525591
7055000633,35574402566128,621505200525623
7055000965,35966800701265,621505200525952
7055001182,35844301188404,621505200526156
7055001352,35350902954276,621505200526325
7055001468,35195101170824,621505200526441
7055001490,35501600003290,621505200526463
7055003310,35487502010707,621505200528256
7055006309,04857558566586,621505200531213
Yes,
that's because the sample data you provided had a different format.
You may try this:
(use nawk or /usr/xpg4/bin/awk on Solaris)
awk>file3 'NR==FNR{_[$1];next}$1 in _' file1 FS=, file2
The field separator is missing from radoulov's script.
awk -F, 'NR==FNR{_[$1];next}$1 in _' gprs2.txt gprs_calls2.txt
Your description of the output you require is not understandable to me. This will print the lines in gprs_calls2.txt whose first field matches a value in (the first field of) gprs2.txt.
The out put is comming but the problem is ,,for the msisdn in file1,their may be chances that 2 lines can match because the column no 2 and 3 of file2 is diffrent.
i required the no which is having duplicate entry should be redrected to another file,and the no which is not duplicate need to redirected another file.
how can i achiev plz help