UNIX for Advanced & Expert Users

If you like, you can also do it with the following two lines:

Code:

sed 's=\(.*\) \(.*\)=awk :{if($4~/^\2/)print $0" \1";else print}: phonelines.txt=' country-codes.txt|tr ':' "'"|sh|awk 'NF==8{print}' >newlines.txt
sed 's=\(.*\) \(.*\)=awk :{if($5~/^\2/)print $0" \1";else print}: newlines.txt=' country-codes.txt|tr ':' "'"|sh|awk 'NF==9{print}'

in which:

phonelines.txt is the file containing your data-lines and
country-codes.txt is the file containing the two-column phone-codes.

Or, for a faster code, execute:

Code:

awk "{$(sed 's=\(.*\) \(.*\)=if($4~/^\2/)print $0\" \1\"=' country-codes.txt)}" phonelines.txt|awk "{$(sed 's=\(.*\) \(.*\)=if($5~/^\2/)print $0\" \1\"=' country-codes.txt)}"

with country-codes.txt containing:

Code:

Egypt-Vodafone 2010
Egypt-Mobinil 2012
Vodafone-UK 447
ZAIN-Sudan 24912
Libya-Madar 21891
Libya-Libyana 21892
Country10-City4 104
Country12-City9 129

and phonelines.txt having your 3 sample lines, the output will be:

Code:

ISC Egypt-Alex2 126 104541338 218926893238 f 1B Country10-City4 Libya-Libyana
ISC BT-Colindale 26 249126190534 218913486850 b 29 ZAIN-Sudan Libya-Madar
ISC Egypt-Cairo2 199 129026052 218927661509 b 26 Country12-City9 Libya-Libyana

Dear Unilover

I would like to thank you very much for your code , i think it is the one that i want ,

Please can you tell me about the sed scripting you used , can you tell for example what /n.* make and so one for the code you created

Regarding speed can your code support up to for example 500,000 lines in short time or it will take much time?

Thnaks very much again
Zanetti

OK, this is what you have to do in order to understand how this code works:

1. Execute:

Code:

sed 's=\(.*\) \(.*\)=if($4~/^\2/)print $0\" \1\"=' country-codes.txt

It will convert each line of the "country-code" to an "if-statements" in awk-language that instructs awk that:

if the forth-field (of the read-in line) starts with the "number" then, print the entire line followed by the "name".

Thus, if you run awk on the phone-lines.txt file with those generated "if-statements" as the executing-commands on the read-in lines, the result will be "addition of the appropriate Country-City-Name to the end of the line, based on the starting number in the forth-field of the read-in line".

You can see it for yourself, by executing:

Code:

awk "{$(sed 's=\(.*\) \(.*\)=if($4~/^\2/)print $0\" \1\"=' country-codes.txt)}" phonelines.txt

Now, we have to add the "Second Country-City-Name to the end of the line, based on the starting number in the fifth-field of the read-in line".

We do this by piping the output of the above-command to another awk who has no phonelines.txt as its file-parameter (so, it will be forced to read the output of the previous awk in the pipe) and, as its set of "if-statements", the same sed is used but this time it is generating "$5~/^ ..." instead of "$4~/^ ..." to instruct (the second) awk that:

if the fifth-field (of the read-in line) starts with the "number" then, print the entire line followed by the "name".

Now, as for the speed, I'm afraid I don't have a 500000 line phonelines.txt file and more than that, it depends on the computer on which you're running this commands. But, one thing that I am very sure of is that both sed and awk are very fast in what they do.

As for the description of how the sed is generating the "if-statements", I would refer you to the description of "Regular Expression" either on the internet onin man-pages.

Good Luck

Dear Unilover

Thanks for your code but i typed it the script you gave me the result is
Variable Syntax

So i think there may problem in Syntax

Please advise

Zanetti

I believe you should have made a mistake in typing. Please copy what you have typed and paste it here so that I can see where the mistake is.

Dear Unilover
this what i have typed for the faster code:

geo@spiserver /home/geo/cdr/ItalyRel 25 > awk "{$(sed 's=\(.*\) \(.*\)=if($4~/^\2/)print $0\" \1\"=' country-codes.txt)}" phonelines.txt|awk "{$(sed 's=\(.*\) \(.*\)=if($5~/^\2/)print $0\" \1\"=' country-codes.txt)}"
Variable syntax

and this is the files in my directory

134 Apr 3 16:56 country-codes.txt
-rw-r--r-- 1 geo geo 0 Apr 3 16:57 final
-rw-r--r-- 1 geo geo 874008 Mar 31 17:50 italy2
-rw-r--r-- 1 geo geo 1151226 Apr 3 17:11 phonelines.txt
-rwxr-xr-x 1 geo geo 133 Apr 3 17:09 script*