CSV Manipulation to MySQL Table
- or -
Post a project like this1203
£50(approx. $61)
- Posted:
- Proposals: 21
- Remote
- #2840955
- Awarded
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,

362013725437782461489430461206743262775450683613554373580499219516924790603084683



Description
Experience Level: Entry
I have an existing CSV file that contains all UK telephone area codes (0113, 01254, 0203 etc etc) - sample file attached.
I need some kind of script that will take existing csv file, and create additional rows to show complete phone numbers from 00000 to 99999
For example existing file has:
Area code
01254
I need script that will either change that or create new output file to:
01254000000
and create all additional rows up to 01254999999
This then needs to happen for all area codes. The existing file has all area codes, and all numbers will have to be 11 digits in length from 00000 to 99999
I have attached excel file showing current data, and sample of data output needed.
A php script would be best so it can be re-used for future files, but happy to look at using VBA or other options, the final file will be being uploaded to a mysql table so you can either code a script that uploads to a table, or a script that creates another csv file and we will manually upload.
Quick turnaround required.
I need some kind of script that will take existing csv file, and create additional rows to show complete phone numbers from 00000 to 99999
For example existing file has:
Area code
01254
I need script that will either change that or create new output file to:
01254000000
and create all additional rows up to 01254999999
This then needs to happen for all area codes. The existing file has all area codes, and all numbers will have to be 11 digits in length from 00000 to 99999
I have attached excel file showing current data, and sample of data output needed.
A php script would be best so it can be re-used for future files, but happy to look at using VBA or other options, the final file will be being uploaded to a mysql table so you can either code a script that uploads to a table, or a script that creates another csv file and we will manually upload.
Quick turnaround required.

Barry P.
100% (31)Projects Completed
26
Freelancers worked with
17
Projects awarded
25%
Last project
27 Dec 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies