I have 2 comma delineated data files. The first (100,000 records) with addresses, with some correct names. Another (over 2 million), with Name, Address and phone number.
I need the first file (100,000 records) top be appended with the correct phone number(s), and correct names.
To qualify you must have some sort of software (program) that does appending, not just matching. sometimes the addresses will be spelled out a bit differently
EG. St., Street, Ave. Avenue
This is the first batch.