Suoritettu

I still need to format phone numbers in csv file

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!

Taidot: tiedonsyöttö, Excel, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: excel macro format phone numbers, ado able read large numbers csv file, phone number csv file, excel macros format phone numbers, format outlook contacts csv file, format phone numbers autocomplete, need 1000 phone numbers, handle large numbers csv file asp net, need 100 phone numbers, find phone numbers excel file, need 1000 phone numbers month creating pvas, need pva phone numbers, need bulk phone numbers, i need a phone number to customer service for zeki tablet 10.1, i need my phone number, i need my phone numerous on telemarketing list, how to format phone numbers in excel 2013, how do i keep a long number format on a csv file?

Tietoa työnantajasta:
( 1 arvostelu ) United States

Projektin tunnus: #22705239

Myönnetty käyttäjälle:

dalsaniyasonu123

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 don Lisää

$30 USD 1 päivässä
(51 Arvostelua)
5.2

14 freelanceria on tarjonnut keskimäärin 25$ tähän työhön

Tanmoy236

"""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 Sa Lisää

$30 USD 7 päivässä
(248 arvostelua)
7.0
goodwork20k

I am good in perl, powershell, csv along with database and data manipulation, please let me know if you are good to award this project to me

$55 USD 2 päivässä
(27 arvostelua)
5.1
shahidul566

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.

$25 USD 1 päivässä
(18 arvostelua)
5.2
BHARATBEURA

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 B Lisää

$30 USD 1 päivässä
(34 arvostelua)
5.0
alekseypankra

!!!!*****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.

$20 USD 2 päivässä
(7 arvostelua)
2.7
reubengi

Hi, Drop me the file and I can do this work for you today. I have good tools and skills to do a quality work on this task. Regards. Reuben

$25 USD 1 päivässä
(3 arvostelua)
1.9
goodlancer117

Hi, I am a senior Web developer with +6 years of experience. I have developed many web sites with laravel, wordpress, shopify, react, angularjs, node.js, vue.js and HTML5/CSS3 Plase check this URL [login to view URL] Lisää

$20 USD 1 päivässä
(0 arvostelua)
0.0
AntonBaranov1115

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 Lisää

$30 USD 2 päivässä
(0 arvostelua)
0.0
Yakshit1

I WILL DO YOUR WORK PERFECTLY AND IN VERY LOW COST, I WILL START WORKING NOW. SO LETS GET STARTED , CONTACT ME AS SOON AS POSSIBLE

$10 USD 2 päivässä
(0 arvostelua)
0.0
ArnikaK

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.

$20 USD 1 päivässä
(0 arvostelua)
0.0
PratimaDewangan

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.

$25 USD 7 päivässä
(0 arvostelua)
0.0
johnyfred

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!

$20 USD 3 päivässä
(0 arvostelua)
0.0
abhishekbhatnaga

Hi I do work on Excel so I will work it And arrange the data in write manner and complete it in given time duration

$15 USD 1 päivässä
(0 arvostelua)
0.0