Format phone numbers in csv file

In Progress Posted 4 years ago Paid on delivery
In Progress 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.

PHP Excel MySQL Data Entry Software Architecture

Project ID: #22675545

About the project

35 proposals Remote project Active 4 years ago

Awarded to:

Ahmed818

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 ⭐⭐⭐⭐⭐

$10 USD in 1 day
(100 Reviews)
5.3

35 freelancers are bidding on average $24 for this job

uhjk

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.

$30 USD in 1 day
(1051 Reviews)
8.4
saqibmunir55

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

$20 USD in 7 days
(683 Reviews)
7.5
onlinejob247

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.

$30 USD in 1 day
(137 Reviews)
6.6
bdrony97

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.

$30 USD in 2 days
(28 Reviews)
6.2
TechnoGuruu

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

$50 USD in 2 days
(103 Reviews)
6.2
engrranakaleem21

ok got it . this will be done according to your requirements. message me so we can discuss more .. thanks..

$10 USD in 1 day
(45 Reviews)
5.2
egg

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.

$15 USD in 1 day
(113 Reviews)
5.3
FreelancerTechX

Hello, it can be done in 1 hour. The dropped leading zero can't be fixed, it's Excel default behavior *****************************************************************************

$30 USD in 1 day
(27 Reviews)
5.3
AnowarRatul

$ 13 Only ---- In just 30 Minutes ----- Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.

$13 USD in 1 day
(120 Reviews)
5.5
IgeS

Hi there, You need have non numeric character like parentheses and dash removed from phone number columns and making number of characters of in zip code columns 6-digit, by adding 0’s to front of non-6 digit zip codes More

$30 USD in 3 days
(23 Reviews)
4.8
Mokshith30

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

$30 USD in 1 day
(43 Reviews)
4.7
vikasg603

Hello sir, i have working solution for this. i have done this in 1 of my project so know very well how to do this. for number i will create one user-defined function in database. and for 5 digit pin code only i will us More

$20 USD in 1 day
(36 Reviews)
4.9
AymunSaif

__________________I am available right now______________________ Hi there, Quality and time is my commitment. I have done this many times, I want to say that, I will start right now and funds will be after your satisfa More

$20 USD in 7 days
(39 Reviews)
4.5
rahulrahangdale

,,..,.............................Hi lets start now..................will do it with 100% accuracy. thanks

$25 USD in 1 day
(34 Reviews)
4.7
IshaqKN

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

$20 USD in 1 day
(29 Reviews)
4.6
mostafawalker

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

$30 USD in 3 days
(22 Reviews)
4.4
ishanawarkhan3

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

$30 USD in 1 day
(4 Reviews)
3.9
AmitShuklaUK

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

$20 USD in 3 days
(1 Review)
0.0
pishupp1992

Dear sir i will perform very well for this job

$25 USD in 3 days
(0 Reviews)
0.0
sosonkyrie

I have a long experience in web development php, mysql, text handling etc and can complete this task successfully

$20 USD in 7 days
(0 Reviews)
0.0