With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Bidding period ended early.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
This is an address cleanup and validation project. We have 132000 records in an excel file. We want to
Phase 1: Clean up this data by moving some information stored with address column to a different column.
Phase 2: Validate the address by comparing against Google Map.
In many cases there is some data appended to the street name field. This data will have to be appended to the "GridNotes". In almost all of the cases, these records with have parenthesis e.g. "( "and " )". In some cases there may be an asterisk.
For every record where this "cleanup" is performed e.g. some data is appended to "GridNotes" field, set the "DC" column flag to 1, otherwise set it to 0.
NOTE: IT is very important that data is "Appended" and any existing notes are not effected
For every record for which there exist a word "prohibited" or "blocked" or "banned", mark the "Prohibited" column with 1, otherwise set it to 0. Also change the "DC" flag to 1.
Save a copy of this final...
Sign in or Register to see more