Find Jobs
Hire Freelancers

Extract Data from Large Fixed Length Text File

$30-250 USD

En curso
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 6095393

Información sobre el proyecto

29 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
29 freelancers están ofertando un promedio de $113 USD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (65 comentarios)
7,3
7,3
Avatar del usuario
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 en 1 día
5,0 (51 comentarios)
6,9
6,9
Avatar del usuario
Hello Sir, I can complete this within 24 hours. Ready to start Thanks, Alex ==============================
$95 USD en 1 día
5,0 (55 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
5,0 (55 comentarios)
6,3
6,3
Avatar del usuario
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 en 0 día
4,9 (55 comentarios)
5,8
5,8
Avatar del usuario
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 en 8 días
4,9 (18 comentarios)
4,4
4,4
Avatar del usuario
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 en 1 día
5,0 (12 comentarios)
3,7
3,7
Avatar del usuario
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 en 2 días
5,0 (9 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,5
2,5
Avatar del usuario
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 en 3 días
5,0 (6 comentarios)
2,3
2,3
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
1,4
1,4
Avatar del usuario
Hi, Please feel free to contact me via private message to discuss project details - Thanks, Supriya >>>>>>>>>>>>>>>>>>
$155 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can automate this and get it done within the specified time. Look forward to working with you. Regards, Alan
$144 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$155 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Providence Village, United States
5,0
121
Forma de pago verificada
Miembro desde mar 16, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.