Hi
We need a solution for our data.
We have a master CSV file with thousands of companies arranged into columns.
Columns are, Name, email, address1, Address 2, etc.
We need a script than will run other CSV's against the master that will
- Search for Duplicate company names and mark them.
- Then provide and option to review the data for the duplicate company one by one
- To be able to "add, replace, merge,ignore" data.
(ie) Company Name: John Smith Interiors, smith street, london, E8 FGY
Duplicate Found:
Company Name: John Smith Interiors, 212 smith street, london, E8 FGY, 07832 714997,info*[login to view URL]
The script will allow us to build and maintain our data base accuracey by:
1. ADD new data to EMPTY cells for example - The email column
2. REPLACE data where new data is more accurate and up to date-such as a new address
3. MERGE data where we are adding new keywords which tag the products that company sells
4. IGNORE data when the master data is the preferred choice
[login to view URL] - Unique and new companies to the master
Its must also Mark with some kind of symbol against the duplicates - so we can see which are unique ( and therefore added to master automatically ) and which are already in the master.
We have been using our web SQL database to do this - and have a script - but need something a step more comprehensive.
Thanks
Helen