I need some formatting done in a csv file. I am migrating shopping cart platforms and I need someone to remove all of the non digit characters and spaces from the phone number columns so that the data can be migrated to the proper fields on the new platform.
I also need to be sure that leading zeros are not dropped in the zip code field for states where the zip code starts with zero. This means that the csv needs to be opened as "text" fields so that the leading zeros are not dropped. I have attached an image of what needs to be done. There are about 21,000 rows and multiple phone number and zip code columns so it will need to be done with some kind of formula or db commands. I posted this two days ago and after one failed attempt and others not responding I still need this done.
Thank you!
Hello,
I am ready to discuss project with you.
Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details.
Looking forward to have further project discussion on chat.
Thanks.
Sapna Dalsaniya
$30 USD in 1 day
5.0 (51 reviews)
5.3
5.3
12 freelancers are bidding on average $26 USD for this job
"""Completed more than 290+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
HII, I’M AN ENTHUSIASTIC DATA ENTRY SPECIALIST. I CAN INPUT DATA WITH ACCURACY IN REASONABLE DELIVERY TIME.
I CAN DO ANY KIND OF DATA ENTRY MAY BE IT IS PDF TO WORD/EXCEL OR COLLECTION OF DATA FROM ANY SITE FOLLOWED BY FILLING THE SPREADSHEET. I CAN ALSO TRANSFER DATA FROM ONE WEBSITE TO ANOTHER AS PER YOUR INSTRUCTIONS.
I AM A DEDICATED AND FULL-TIME FREELANCING IS MY PROFESSION. AWARD ME THIS PROJECT SO THAT I CAN IMMEDIATELY START TO WORK.
Hi dear,
I am well to use excel and formatting data . So if you want I can help you to formatting your phone and Zip code data as your shown way.
I will wait for your reply.
Thanks.
Shahidul.
!!!!*****Let's work with me*****!!!!
I have 5+ years of experience in Php, Web Design , Wordpress, Codeigniter, Laravel,Html,Css,MySQL.
Let me know if I can any help you
Thanks.
Dear client
I am familiar with python projects.
In particular, ML and predict trading is my top skill.
I am sure I can finish your project perfectly as you want.
I will do your job with better budget and I will finish task
very quickly.
Hope to give me the chance to service for you.
I will do my best for you in the future if you award me.
Thanks
Hello,
As a data engineer, I have worked in web scraping, data wrangling, mining and presentation. I believe, with my experience, I can complete the job with satisfaction on time.
Hi, this is just formula based work. Easy yet needs to be cross-checked after the process as the rules don't apply to some cells that have a different format in csv.