Đã hoàn thành

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



Kĩ năng: MySQL, PHP

Xem nhiều hơn: 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

Về Bên Thuê:
( 11 nhận xét ) Garland, United States

ID dự án: #16811358

Được trao cho:


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 Thêm

$10 USD trong 0 ngày
(7 Đánh Giá)

12 freelancer đang chào giá trung bình $26 cho công việc này


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 Thêm

$30 USD trong 1 ngày
(978 Nhận xét)

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 Thêm

$27 USD trong 1 ngày
(33 Nhận xét)

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 trong 1 ngày
(16 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(31 Nhận xét)

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 Thêm

$35 USD trong 1 ngày
(13 Nhận xét)

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 Thêm

$35 USD trong 0 ngày
(6 Nhận xét)

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 Thêm

$30 USD trong 1 ngày
(2 Nhận xét)
$30 USD trong 1 ngày
(11 Nhận xét)

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 Thêm

$15 USD trong 1 ngày
(4 Nhận xét)

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 trong 1 ngày
(0 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)