Find Jobs
Hire Freelancers

Extract Data from Large Fixed Length Text File

$30-250 USD

In Progress
Posted almost 10 years ago

$30-250 USD

Paid on delivery
In the attached zip file is a text file named PILOT.txt. It is to large to be opened with excel or notepad. There is a [login to view URL] file included which explains the data inside the [login to view URL] file. The data needs to be extracted using methods such as MS Access or other database programs. I would like the following information extracted from the file: First name Last name Street 1 Street 2 City State Zip Code Certificate Type Certificate Level Using the following requirements: 1) The address must be in the United States 2) The certificate type must be "P" 3) The certificate level must be "A" or "C" Provided in the following format: 1) Excel CSV file 2) A minimum of one separate Excel file per state, more than one Excel file can be used if there is to much data.
Project ID: 6095393

About the project

29 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
29 freelancers are bidding on average $113 USD for this job
User Avatar
Hi There, I downloaded the file and imported the data to excel sheets as well. Actually the data is sufficient for 2 sheets. Please message me. I have few doubts regarding the data requirement. Thank you. KalpanaSekhar
$147 USD in 2 days
5.0 (65 reviews)
7.3
7.3
User Avatar
Hello, i can extract the data and split the files by states within a day. If you are interested in my bid, please contact me. Thank You. Best Regards.
$94 USD in 1 day
5.0 (51 reviews)
6.9
6.9
User Avatar
Hello Sir, I can complete this within 24 hours. Ready to start Thanks, Alex ==============================
$95 USD in 1 day
5.0 (55 reviews)
6.2
6.2
User Avatar
Hi, I'm an expert in projects like yours with very good feedback and completion rate. I fully understood your requirement and ready to do it for you. The cost is $80 whithin 1 day. Regards, svteam.
$80 USD in 1 day
5.0 (55 reviews)
6.3
6.3
User Avatar
Hi, I'm expert in data processing that's why I'm sure you'll be impressed with my work. I can process your file in less than a day and I can offer you best price here. Please give me a link to your file (may be Dropbox?) and I'll check it and send you sample output. Thanks. Roman
$54 USD in 0 day
4.9 (55 reviews)
5.8
5.8
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 USD in 8 days
4.9 (18 reviews)
4.4
4.4
User Avatar
Hi, I have looked at both files and have understood your requirements clearly. If you like, I can provide a sample data of first few thousand rows. Please message me if you are interested in sample. I will provide sample in 10 minutes, once I got your confirmation message. Thanks
$111 USD in 1 day
5.0 (12 reviews)
3.7
3.7
User Avatar
i can extract the data for you. .i have skilled in data extraction and large file processing. i can extract the data for you. .i have skilled in data extraction and large file processing.
$84 USD in 2 days
5.0 (9 reviews)
3.2
3.2
User Avatar
We have to be very careful of your project and we are very interesting. We promise to work hard to finish on time for assigned work. Hope to get feedback from you soon so that we can begin to discuss more details about the project and we are ready. Best regards!
$100 USD in 1 day
5.0 (2 reviews)
2.5
2.5
User Avatar
Hello, I have imported data in access but it didn't went into columns as there was no delimeter in text file. I can manually format the data into columns. There are 1409046 records. Looking forward for the reply. Regards, Aditya
$77 USD in 3 days
5.0 (6 reviews)
2.3
2.3
User Avatar
Hi. Certainly i can do it for you with that price. I did completed 100% projects for all my employers and they are very satisfied with my result. You can check it in my profile. Hope we have a deal. Thank you!
$100 USD in 2 days
5.0 (1 review)
1.4
1.4
User Avatar
Hi, Please feel free to contact me via private message to discuss project details - Thanks, Supriya >>>>>>>>>>>>>>>>>>
$155 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
SECOND UPDATE: I've opened the file and uploaded it to a MySQL database. UPDATED. I've reviewed the file description. If hired I can and will extract the information you need. Please award me this project. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Good Evening. You forgot to attach the file. But this kind of work is something I... well, love doing. Really, this kind of data analysis is fun (for me)! I would really like this opportunity. Yours, --Vinicius Zolin
$133 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
Hi, This is my first bid on freelancer. I have a lot of experience with ssis and extracting data from large files. I have previously written a data extract that ran every morning and imported 3.4 million records into sql server in less than 5 minutes. Regards, Syed
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have a lot of experience in data crunching, able to develop ad-hoc scripts and software that can open for viewing editing enormous-size files: snip: ------------- A000000600VICTOR AVILA 29 HALF MOON BAY DR CORONA DEL MAR CA92625-1039USA WP3092013092015 A000003000WILLIAM VERNON CHAPIN ------------------- i can start immediately to work to this task, with max precision/speed, feedbcking you all the time. The fee includes what you requested + an access database, correctly indexed, with the possibility to query/exporting reports in excel
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can automate this and get it done within the specified time. Look forward to working with you. Regards, Alan
$144 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good experience on working on large text file and extracting data using PERL scripts and C code to databases such MySQL, SQL Server. The Data can be subsequently stored in csv files or other desired file formats. My experience includes working large genomic data files downloaded from online resources.
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
First I will explain my assumptions about task: - There is no need to use any database. Simple python script will suffice and this is the method I will use. - Files per state - I assume there is no need to generate files for states without matching entries. In addition to result CSV files I will add python script used to generate them Best regards
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Providence Village, United States
5.0
121
Payment method verified
Member since Mar 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.