I gang

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

Evner: PHP, Excel, MySQL, Dataindførsel, Software Arkitektur

Se mere: how to save phone numbers in csv, the csv data format must be set to text when the file is saved, phone number not importing google contacts, how to create csv file for mobile contacts, how to format a csv file, google csv format, how to keep number format in csv file, csv file not importing correctly, excel macro format phone numbers, convert csv file format, extract phone numbers file, add format csv file, outlook 2003 csv file format example, csv file format outlook address book, outlook csv file format, writing output csv file format python, csv file exchange format, convert address book csv file format, ado able read large numbers csv file, excel csv file format

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #22675545

Tildelt til:

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 på 1 dag
(74 bedømmelser)
5.0

38 freelancere byder i gennemsnit $24 på dette 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 på 1 dag
(950 bedømmelser)
8.3
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 dage
(637 bedømmelser)
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 på 1 dag
(129 bedømmelser)
6.6
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 Flere

$50 USD in 2 dage
(98 bedømmelser)
6.1
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 dage
(28 bedømmelser)
6.0
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 på 1 dag
(110 bedømmelser)
5.3
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 på 1 dag
(42 bedømmelser)
4.6
apuspo49

yes i have read the project and can fix all the problem and format it well can you please send me a message so we can discuss more and start. it will cost $ 35 for all 21,000 rows. Thanks anjuman

$30 USD in 7 dage
(21 bedømmelser)
4.9
michaels225

It's a piece of cake for me Hi, sir Thank you for your job posting. I have enough experience with VBA, Excel, Data Processing. So, I am very confident to satisfy you absolutely. Let's achieve success together. Thank y Flere

$20 USD på 1 dag
(22 bedømmelser)
4.8
FreelancerTechX

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

$30 USD på 1 dag
(15 bedømmelser)
4.7
AnowarRatul

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

$13 USD på 1 dag
(51 bedømmelser)
4.5
rahulrahangdale

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

$25 USD på 1 dag
(29 bedømmelser)
4.6
engrranakaleem21

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

$10 USD på 1 dag
(26 bedømmelser)
4.5
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 dage
(15 bedømmelser)
4.2
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 Flere

$30 USD in 3 dage
(8 bedømmelser)
4.2
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 på 1 dag
(10 bedømmelser)
3.7
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 Flere

$20 USD in 7 dage
(22 bedømmelser)
3.9
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 Flere

$20 USD på 1 dag
(10 bedømmelser)
2.9
Sbnayak24

Good at MS office tools. Can deliver the project with short lead time. Assignment completion is the goal.

$20 USD in 5 dage
(0 bedømmelser)
0.0
pishupp1992

Dear sir i will perform very well for this job

$25 USD in 3 dage
(0 bedømmelser)
0.0