Format phone numbers in csv file
$10-30 USD
Paid on delivery
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. I have attached an image of what needs to be done. There are about 21,000 rows and multiple columns so it will need to be done with some kind of formula or db commands.
Project ID: #22675545
About the project
Awarded to:
Hello, ⭐⭐⭐⭐⭐ i am interested in this project , it is very easy job for me , can finish it within 1 hour max i can begin now waiting your answer on chat Thank you ⭐⭐⭐⭐⭐
35 freelancers are bidding on average $24 for this job
Hello, if you send me csv file I can send you output file in 1 hour. I will use php to generate new file. Thanks.
send me sheets,i will correct both formats,zip codes + phone numbers,i have checked the images already,and know what u need thank you
Okay. I have huge experience in working with these projects and will give you 100% accurate work. If you need sample work just send me a message. Waiting for your quick reply.
Ready to do this now. Just send me the excel sheet. I am ready to do this and I will complete this within very short time.
Hi, As per requirements I will cleanup your data as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high More
ok got it . this will be done according to your requirements. message me so we can discuss more .. thanks..
Hello,sir I have read your project details carefully. I checked the pic too. I can help you to do it. Can be done in 1 hour. I can delivery a programe so you can process your data future.
Hello, it can be done in 1 hour. The dropped leading zero can't be fixed, it's Excel default behavior *****************************************************************************
$ 13 Only ---- In just 30 Minutes ----- Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.
Hi I am VBA Developer Experianced in VBA Macros & web scraping i can finish this task in a day only pls share the details thanks
,,..,.............................Hi lets start now..................will do it with 100% accuracy. thanks
Hi there, Yes I will format your data as per your spec. I am expert of data processing + regex. Short Python script will do your task. Can you trust me for your project? Best regards, Ishaq
I'm highly skilled c# programmer and desktop developer I can help in your requirements and filter this csv with simple script application I'll write in c# , please contact me to start and discuss details
Hi I checked your image file and I am available right now to start your work with quality Contact me ans start work Regards Shanawar Iqbal
Hi, I am a developer and have 10 yrs experience in scraping and data formatting. I am able to do your task. If you can assign me then deliver on time. Thanks
I have a long experience in web development php, mysql, text handling etc and can complete this task successfully