Hello - I have a spreadsheet that has 36,000 records. Each record has 15 text fields shown below. Most of the records have the address combined in one fields such as "985 Parker [url removed, login to view] Clara, CA 95050" .... I need someone to do three things to the data set.
1. Break the address into the individual fields such as:
Address = 985 Parker Ct.
City = Santa Clara
State = CA
Zip = 95050
2. Convert all UPPERCASE text to Sentence Case.
3. Deduplicate the records based on the "Company" field... Deduplicate by using one address, phone and email
and then combine the data from the other duplicate fields.
15 freelancers are bidding on average $120 for this job
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.
Hello, Excel VBA expert here. Please check PM for details. Thanks!
Greetings, I am very interested in your data cleansing project. I have many years of data manipulation/database development experience and I am available to begin work on your project immediately. I would like t Daha Fazla
Defiantly I can provide fair MYSQL/PHP solution in this reagard. thanks
i can do it for you. contact me and give me more detail
I have considerable experience data cleansing address data for large organisations with data sets exceeding tens of millions of records.
I am expert in excel and have 3 year experience in [url removed, login to view] i am doing working for a firm where i am handle 2500 worker sallary and other expense through [url removed, login to view] Give me a chance for work.
Hi I am a new freelancer with 9+ years experience in PHP, Java, MySQL, SQLServer and Data scraping. I feel I can do this in a day or two if my understanding is correct. Rest I am putting on your PM.