I'll provide a list of addresses in 1 excel column.
The addresses are formatted like this:
Knutton Lane<br> Newcastle-under-Lyme<br> Staffordshire<br> ST5 2GB<br> <a target="_blank" href="[login to view URL],-2.237987">Find on Google map
The task will consist in splitting the address in 4 columns:
In this example shown it will be like this:
Column4=Postal Code=ST5 2GB
Column5=Country=England...this is not appearing in the excel, it has to be filled with England/Wales/Scotland/Northern Ireland depending on the County (a list with all the towns/counties/Countries will be provided).
Issues to take into account:
1. This is not only a mechanic task (like splitting text inside <br> tags): some addresses will not have the data regarding street address or county or town or Postal Code. This has to be taken into account.
2. Names of cities: have to be standarized. For example: "Newcastle-under-Lyme" could appear in the list as "Newcastle under Lyme" or "newcastle-under-lyme". All the city names have to be standarized. The same for the names of counties.
3. Names of counties have to be filled if they are empty. A list of cities/counties will be provided, see it attached.
The task has to be done fast: in 1 day or 2 days maximum.
Hi There, Hope you are fine today! Please share more details in chat, I am able to start the work now. I am promising for my best work quality with on-time delivery. I am hardworking always and passionate about to wo Daha Fazla
Hi, I could easily provide you with the standardized list within a few hours. I'll start working on it as soon as I get accepted for the job. This shouldn't take me long and you could be sure that most of the fuzzy Daha Fazla
Bu iş için 37 freelancer ortalamada $104 teklif veriyor
Hello Sir I have seen the excel file and i hope is a type of work few hours, If everything's are fine in the given file. Thanks
Hi there, I can standardize a list of addresses in excel. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Greetings! Dear sir,I believe honesty is the best policy. My main target is to supply high-quality work with reasonable cost. I am expert on Email Collection, Data Entry, Internet Research. I have more than 4 years Daha Fazla
Hello! I can finish the task in 1 day. I can start now. I will standardize your file without error. You will not be dissapointed, I have a big 34% rehire rate. Thank you!
Hello, this is strictly data manipulation task and i can do this using python, can you please message me so that we can discuss more? well i need 1-2 days MAX, thanks!
Hello Sir, I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then p Daha Fazla
Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I cou Daha Fazla
Hello there! I have read the project description carefully and would like to be considered for your project. I can filter & format the data according to the provided guideline with 100% accuracy. I have a team of Daha Fazla
I read your requirement and I can get this done with in a day. Please award the job and I will send you the output file
Dear sir I perused your job offer and see the attached files. I already did 90% work is complete to your file. I'll provide sample work in interviews. I am able to complete this task within your mean time. Lookin Daha Fazla
Hi, I gone through task description and attached excel and csv. I understood your requirement. I can do this job perfectly within budget and within time frame. thanks Pallavi
I have checked the attached files .Hello Esteemed Client I am very organised person, I am efficient in Microsoft Excel. I am a hard worker, type quickly, and can ensure your data is entered accurately I am very accura Daha Fazla
Hello Sir/Madam Data is in tagging mode. I can give you the output in required mode on deadline time (2-3 days). Please come to chat to discuss more. Thank you.