4225 Parse Script Needed

I am in the need of a script to parse a text file. The solution must be in either Perl (or any other linux-based solution) or, less preferably, MS VBA. I have attached an example input file to be parsed. Final output will be to a MySQL table. Please review the attached text file before bidding on this project. The file is an inventory usage report and is, hopefully, pretty self-explanatory. The main column headings are: Item, Ending Units, Unit of Measure, Beginning Inventory, Purchases, Ending Inventory (the remaining columns will be calculated and not needed). The output file should be either: 1. Read into a MySQL table by your script 2. Output in a format suitable to import into MySQL The required output columns: (I have put a description, where needed, in brackets). Item, End_Units, UOM [unit of measure], unit_cost, beg_inv, purchases, end_inv, dept [Dept is found as a heading], group [also a category heading], subgroup [heading], beg_date, end_date, run_date Note that all date info is found in first few lines of file the input file. Please be specific in your proposed solution for this project.

Taidot: kaikki käy, MySQL, Perl, PHP, Python, Visual Basic

Näytä lisää: import ms project, parsed, parse, parse and, vba mysql php, output script, parse table, linux import mysql script, php brackets, php mysql import script, table heading, example mysql script, linux read text file, parse lines file, mysql parse date, script import, php script read table, table perl, perl table, parse php, mysql output table, brackets, import needed, table inventory php script, inventory script php

Tietoa työnantajasta:
( 0 arvostelua )

Projektin tunnus: #1755094