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.
14 freelanceria on tarjonnut keskimäärin 25$ tähän työhön
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.
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.
It is an easy job for me. I have worked with CSVs in my hard works like data mining and I know all of its challenges. I can code for it that it can be done ASAP. Thanks if you trust me!