Matching values in two files.

From: Alistair McKeown (Alistair.Mckeown_at_jacobsrimell.com)
Date: 03/24/05

  • Next message: David Landgren: "Different behaviour between accounts for ssh connections" 
    To: "'sunmanagers@sunmanagers.org'" <sunmanagers@sunmanagers.org>
Date: Thu, 24 Mar 2005 08:51:09 -0000

    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

  • Next message: David Landgren: "Different behaviour between accounts for ssh connections"