Merge 2 csv files
Posted August 21st, 2008 by bpeterson
I would like to merge 2 files: 1 file has name, phone number and email address(1.2 million) and 1 file has name and phone number(12,000). I would like to to extract the 12,000 emaill addresses that have corresponding names or phone numbers. I have only been successful in matching 700 of the 12,000. It is possible that the names on the 2 lists are not exactly the same eg. Robert Smith vs. Bob Smith. Is there a way to merge these lists with names that are close even if I get some false positives?
Your transaction secured by high-grade AES-256 encryption.
RE: Merge 2 csv files
Hi bpeterson,
The data in the data field on which you wish to "match" records from the two files must match exactly. In other words, the data "Robert Smith" and "Bob Smith" will not result in a match.
Perhaps the email address data fields or telephone number data fields would result in more matches and/or result in more accurate matches.
- Jo