Parse fixed length txt file and load to mysql table - 28/04/2018 07:11 EDT

I have a file written by a mainframe i need to parse and load into mysql table:

foreach file in a folder

unzip the file

parse .txt file based on business rules (zip contains 2 files, i am only interest in the txt file)

insert rows to mysql table

move zip file to new folder

delete the zip file

i will supply test data and business rules. the business rules will be like

ignore rows before row contains the string 'abcdefg'

skip next row

parse data row and remove training whitespace

skip next row



if row contains '-------', write record

start new row



Habilidades: MySQL, PHP

Veja mais: perl load mysql table, php parse txt file mysql, parse txt file mysql, explain parse mysql txt file, parsing txt file saving mysql database, parse txt file php mysql data base, excel file data mysql table java, write txt file mysql table php, load xml file mysql table, php read txt file insert mysql, mapping fixed length data file data mapping tool, parse xml file mysql table, mysql table xml file, parse txt file database table, parse txt file php

Acerca do Empregador:
( 11 comentários ) Garland, United States

ID do Projeto: #16811358

Concedido a:


Hi, (updating as discussed) I have used php to parse many types of text files, including some very complex and large files (2GB+) I can easily create a script to parse the files as per your business rules. let me Mais

$10 USD em 0 dias
(7 Comentários)

12 freelancers estão ofertando em média $26 para esse trabalho


Hi there I have worked with fixed length text files. I can process the zip files containing fixed length text files and load them to the MySQL table according to the business rules outlined in the project descriptio Mais

$30 USD em 1 dia
(978 Comentários)

Hello Sir/Madam, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have done 100+ projects with full satisfaction of my clients in web design and develo Mais

$27 USD em 1 dia
(33 Comentários)

Hey!! I can surely get this done. Skills: PHP, WordPress, HTML5/CSS3/Bootstrap3, JavaScript, Jquery Looking forward for a positive response from your side. Regards!!

$24 USD em 1 dia
(16 Comentários)

Dear Sir, I am an independent freelancer having experience of more than 8 years. I am highly experienced in php, html, css, javascript, jQuery, Ajax, Codeigniter, bootstrap etc. I can fulfill your requirement with gua Mais

$25 USD em 1 dia
(31 Comentários)

Hi, I am a PHP developer working on many projects with the framework like Laravel,Angular.js, Yii etc. You are looking for Parse fixed length txt file and load to mysql table . I have 5 years experience in Databas Mais

$35 USD em 1 dia
(13 Comentários)

Hi, I'm a php developer and a DBA with many years experience with DBMs such as mysql, postgresql, sqlserver, etc. I can help you with this, looks pretty straightforward, I think I can get it done within a few hours. Ho Mais

$35 USD in 0 dias
(6 Comentários)

Hello, You have web-server setup for this job? Anyway, ready to delever today, in 1-2 hours. Really easy one task. ---- I always look carefully at the task and bid only personally, not just copy-pasting whatever pr Mais

$30 USD em 1 dia
(2 Comentários)
$30 USD em 1 dia
(11 Comentários)

I am mohan choudhary, 3+ years experienced in websites and e-commerce development using HTML, HTML5, cSS, PHP/MySQL, Cake Php, laravel, Anguler JS, Android,wordpress, IOS. * I Have best experience in laravel Framewo Mais

$15 USD em 1 dia
(4 Comentários)

hi dear i already have this code on my system i can do it if you want to see this code work on my system i can show it to you

$25 USD em 1 dia
(0 Comentários)
$25 USD em 1 dia
(0 Comentários)