Data Manipulation - Data Entry Microsoft Excel Database
I have approximately 5000 records of names and addresses in a CSV file. Within each record are a 15 fields and one of those fields has 2 pieces of information in it. The information is the house number and the street name. The requirement is to separate these 2 pieces of information from the single field into 2 separate fields. One field containing the house number and the other field containing the street name. The data to be returned will be 17 fields for each record, comprising the 15 original fields and the 2 additional fields (House number and Street name), in a csv file. When you consider submitting for this work please review the example data carefully. I have provided the original data and then fields 7 and 8 represent the division of field 6. Please note the term house number is a loose descriptive term an actual house number may be Lot 75 or Rmb 502 or simply the number 17, it may not be simply a number but rather a term such as Lot or Rmb followed by a number, or there may be possibly no house number at all. Refer to the attached file as an example of the separation. Please price the job per record, do not price the job on a per hour basis. The job is a rush job so will be required to be completed within 5 days of the contract being awarded. This is a strict deadline and extensions cannot be given Please do not hesitate to ask questions if any aspect is unclear. Desired Skills: Data Entry Microsoft Excel Database Keywords: Data Entry
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."