En cours

Bulk Data Extraction to .CSV Files

Data Extraction

I have several data sources ranging from business databases to email lists. All of these data sources are in .csv format. For example, I have a USA business database that includes all businesses in the USA. This data is broken up into 50 individual .csv files (one .csv file per state).

I need to be able to extract and create individual .csv files based on certain filters. For example, I want to create individual .csv files for attorneys based on each zip code. I need a script that can query all the data in a directory (for example the directory that has all the .csv files) and it will output this data into multiple (in most cases thousands) of individual files.

I need to be able to select the filters and the file output needs to be named according to the content of the file.

For example, the attached data sample is a small exert from the state of Alaska. In the same directory, I have 49 other .csv files in the same format. I want to be able to select a couple criteria and run a script to create individual .csv files. For example, if I wanted file creation for Attorneys with SIC code of 811103 separated by zip codes, the script would create a unique .csv file for each zip code for attorneys. If there were 500 records for attorneys in zip code 99501 the name of the output file would be [url removed, login to view] and the next output file might be [url removed, login to view] etc. Running the query on the entire directory containing the .csv files would create tens of thousands of individual .csv files that would be named according to the contents of that file.

This script needs to be able to be loaded locally on the computer with the data. The script needs to be able to have different filters selected to determine the file output.

Compétences : Exploitation de Données, Traitement de Données, Excel, SQL, Web Scraping

Voir plus : bulk data extraction, data extraction csv file, named query, excel exert, csv codes, codes sources, business attorneys, attorneys in, attorneys directory, attorneys attorneys, alaska usa, attached files, query creation, files email, excel-to-csv, Excel to CSV, database extraction, data-extraction, data query, csv, bulk file, alaska, csv file business directory, business wanted database, extract excel files

Concernant l'employeur :
( 7 commentaires ) Dallas, United States

N° du projet : #1080141

Décerné à :

silentius

Hi, please see PM, thanks.

250 $ USD en 10 jours
(1 Commentaire)
2.8

58 freelance ont fait une offre moyenne de 327 $ pour ce travail

greggfletcher

Hello, i can help you with this project. If interested please contact me. Thanks.

400 $ USD en 7 jours
(66 Commentaires)
6.7
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

400 $ USD en 7 jours
(56 Commentaires)
6.7
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

300 $ USD en 5 jours
(78 Commentaires)
6.3
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

250 $ USD en 5 jours
(60 Commentaires)
6.3
srinichal

I can deliver the script to your needs

280 $ USD en 4 jours
(30 Commentaires)
6.1
aruhat

Dear Client, Please see PM. Regards, Chandni

750 $ USD en 7 jours
(8 Commentaires)
6.0
phpXpertbd

Please see pm. Thanks

250 $ USD en 4 jours
(19 Commentaires)
5.8
panfreelancer

Please check PM. Thanks

450 $ USD en 7 jours
(50 Commentaires)
5.7
svteam

Hi, see PM please. Thanks.

250 $ USD en 1 jour
(44 Commentaires)
5.6
ineedWorkJob

sir plz check pm !

250 $ USD en 3 jours
(41 Commentaires)
5.4
thanhlongfree

Hello. Please check PM

250 $ USD en 5 jours
(20 Commentaires)
5.3
rhomeu

Advanced MS Access with VBA developer here. I can create system in MS Access for you. Please check private message. Thank you!

250 $ USD en 1 jour
(11 Commentaires)
5.3
soner

I can offer my high quality web scraping services to you. Please contact if interested. I am expert.

650 $ USD en 0 jours
(10 Commentaires)
5.2
Krusche

Hi, we have reviewed your description and examples and prototyped the solution. Whereas it is not a too great challenge to parse and process the data and generate the output according to the given filters, it will be q Plus

720 $ USD en 5 jours
(21 Commentaires)
5.2
aoefmpes

pl check PM

250 $ USD en 5 jours
(28 Commentaires)
4.9
northwolves

See PMB please

250 $ USD en 4 jours
(40 Commentaires)
4.8
rodelacidera

Hi, please check PM. regards

250 $ USD en 2 jours
(5 Commentaires)
4.6
ExactSystems

Please see detail on PMB. regards

350 $ USD en 7 jours
(5 Commentaires)
4.6
telemarketing555

Hi, please check your PM. Thank you.

250 $ USD en 5 jours
(22 Commentaires)
4.3
aptecpymefree

Hi. I Can create your Bulk Data Extraction to .CSV Files program.I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please Plus

250 $ USD en 7 jours
(3 Commentaires)
4.1