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



Kemahiran: MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 11 ulasan ) Garland, United States

ID Projek: #16811358

Dianugerahkan kepada:


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 Lagi

$10 USD dalam 0 hari
(7 Ulasan)

12 pekerja bebas membida secara purata $26 untuk pekerjaan ini


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 Lagi

$30 USD dalam sehari
(978 Ulasan)

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 Lagi

$27 USD dalam sehari
(33 Ulasan)

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 dalam sehari
(16 Ulasan)

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 Lagi

$25 USD dalam sehari
(31 Ulasan)

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 Lagi

$35 USD dalam sehari
(13 Ulasan)

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 Lagi

$35 USD dalam 0 hari
(6 Ulasan)

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 Lagi

$30 USD dalam sehari
(2 Ulasan)
$30 USD dalam sehari
(11 Ulasan)

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 Lagi

$15 USD dalam sehari
(4 Ulasan)

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 dalam sehari
(0 Ulasan)
$25 USD dalam sehari
(0 Ulasan)