Below there are snippets of data from 2 file structures I have.
The first structure is simply a telephone number. The 2nd is structured differently. It also contains a phone number but has a couple characters in front of it and has a domain name after it. Please look below at the samples. I need to flag the numbers in the first file which only have phone numbers and append the matching domain name to them from the 2nd file.
I have 86 files of the 2nd kind which are almost 200mb each and have about 3 million lines.
Any and all help would be greatly appreciated. Please provide as many detailed instructions as possible.
Thanks!!!!!!
File 1:
2012001988
2012221122
2012222222
2012222222
2012243310
2012259297
2012259553
2012323494
2012407625
2012436385
2012436579
2012440499
2012445058
2012616081
2012621297
2012647883
File 2:
AA2013162981,myboostmobile.com
AA2013162982,myboostmobile.com
AA2013162983,myboostmobile.com
AA2013162984,myboostmobile.com
AA2013162985,myboostmobile.com
AA2013162986,myboostmobile.com
AA2013162987,myboostmobile.com
AA2013162988,myboostmobile.com
AA2013162989,myboostmobile.com
AA2013162990,myboostmobile.com
AA2013162991,myboostmobile.com
AA2013162992,myboostmobile.com
AA2013162993,myboostmobile.com
AA2012221122,myboostmobile.com
AA2013162995,myboostmobile.com
AA2013162996,myboostmobile.com
AA2013162997,myboostmobile.com
AA2013162998,myboostmobile.com
AA2013162999,myboostmobile.com
AA2013163000,vtext.com
AA2013163001,vtext.com
AA2013163002,vtext.com
AA2013163003,vtext.com
AA2013163004,vtext.com
AA2013163005,vtext.com
AA2013163006,vtext.com
AA2013163007,vtext.com
AA2013163008,vtext.com
The first structure is simply a telephone number. The 2nd is structured differently. It also contains a phone number but has a couple characters in front of it and has a domain name after it. Please look below at the samples. I need to flag the numbers in the first file which only have phone numbers and append the matching domain name to them from the 2nd file.
I have 86 files of the 2nd kind which are almost 200mb each and have about 3 million lines.
Any and all help would be greatly appreciated. Please provide as many detailed instructions as possible.
Thanks!!!!!!
File 1:
2012001988
2012221122
2012222222
2012222222
2012243310
2012259297
2012259553
2012323494
2012407625
2012436385
2012436579
2012440499
2012445058
2012616081
2012621297
2012647883
File 2:
AA2013162981,myboostmobile.com
AA2013162982,myboostmobile.com
AA2013162983,myboostmobile.com
AA2013162984,myboostmobile.com
AA2013162985,myboostmobile.com
AA2013162986,myboostmobile.com
AA2013162987,myboostmobile.com
AA2013162988,myboostmobile.com
AA2013162989,myboostmobile.com
AA2013162990,myboostmobile.com
AA2013162991,myboostmobile.com
AA2013162992,myboostmobile.com
AA2013162993,myboostmobile.com
AA2012221122,myboostmobile.com
AA2013162995,myboostmobile.com
AA2013162996,myboostmobile.com
AA2013162997,myboostmobile.com
AA2013162998,myboostmobile.com
AA2013162999,myboostmobile.com
AA2013163000,vtext.com
AA2013163001,vtext.com
AA2013163002,vtext.com
AA2013163003,vtext.com
AA2013163004,vtext.com
AA2013163005,vtext.com
AA2013163006,vtext.com
AA2013163007,vtext.com
AA2013163008,vtext.com