Matching values in two files.

From: Alistair McKeown (Alistair.Mckeown@jacobsrimell.com)
Date: Thu Mar 24 2005 - 03:51:09 EST


Hi Gurus,

I have two files that I want to match billing numbers list in one file then
match these two another then put on the lines of the 2nd file with the
billing numbers in. I've done a perl script but it didn't work properly.

i.e

First file a list of billing numbers :

5273163
5175633

Second file list of users and their billing numbers :

6686828,D,Schenk,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta1,VOIP45664
5273163,CA,Laerhoven,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta3,VOIP45666
5306268,BMW,Valkenburg,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta4,VOIP45667
6747384,I,Storm,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta6,VOIP45669
5175633,CA,Cabaret,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta8,VOIP45671
6695451,M.,Jong,,,AD00MGA01,0,False,INT00705264,Abonnement chello
Easy,,,mta11,VOIP45674
5317329,L,Wiegmans,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta14,VOIP45677

Output file would be :

5273163,CA,Laerhoven,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta3,VOIP45666
5175633,CA,Cabaret,,,AD00MGA01,0,,,,,UPC Telefonie
(Jaarcontract),mta8,VOIP45671

Does anyone know how to produce this output from matching up the billing
numbers.

Regards,

Alistair.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:30:25 EDT