Suoritettu

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 [login to view URL] and the next output file might be [login to view URL] 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.

Taidot: tiedonlouhinta, tietojenkäsittely, Excel, SQL, Tietojen kaavinta verkosta

Näytä lisää: 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

Tietoa työnantajasta:
( 7 arvostelua ) Dallas, United States

Projektin tunnus: #1080141

Myönnetty käyttäjälle:

silentius

Hi, please see PM, thanks.

$250 USD 10 päivässä
(1 arvostelu)
2.8

57 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

greggfletcher

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

$400 USD 7 päivässä
(129 arvostelua)
7.6
SigmaVisual

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

$400 USD 7 päivässä
(75 arvostelua)
7.0
phpXpertbd

Please see pm. Thanks

$250 USD 4 päivässä
(67 arvostelua)
7.1
srinichal

I can deliver the script to your needs

$280 USD 4 päivässä
(75 arvostelua)
6.8
svteam

Hi, see PM please. Thanks.

$250 USD 1 päivässä
(91 arvostelua)
6.7
bharanisrihari

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

$250 USD 5 päivässä
(67 arvostelua)
6.3
panfreelancer

Please check PM. Thanks

$450 USD 7 päivässä
(98 arvostelua)
6.1
schandraram

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

$300 USD 5 päivässä
(55 arvostelua)
6.1
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 1 päivässä
(16 arvostelua)
5.7
ineedWorkJob

sir plz check pm !

$250 USD 3 päivässä
(49 arvostelua)
5.7
soner

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

$650 USD 0 päivässä
(10 arvostelua)
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 Lisää

$720 USD 5 päivässä
(21 arvostelua)
5.1
northwolves

See PMB please

$250 USD 4 päivässä
(57 arvostelua)
5.2
thanhlongfree

Hello. Please check PM

$250 USD 5 päivässä
(25 arvostelua)
5.5
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 Lisää

$250 USD 7 päivässä
(4 arvostelua)
4.9
rodelacidera

Hi, please check PM. regards

$250 USD 2 päivässä
(5 arvostelua)
4.5
aruhat

Dear Client, Please see PM. Regards, Chandni

$750 USD 7 päivässä
(5 arvostelua)
5.9
ExactSystems

Please see detail on PMB. regards

$350 USD 7 päivässä
(5 arvostelua)
4.6
DeoTech

Hi! Kindly see PM. Regards.

$350 USD 10 päivässä
(12 arvostelua)
4.6
telemarketing555

Hi, please check your PM. Thank you.

$250 USD 5 päivässä
(22 arvostelua)
4.3