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ää: vba mysql php, output script, linux import mysql script, php brackets, php mysql import script, table heading, example mysql script, linux read text file, script import, php script read table, table perl, perl table, mysql output table, brackets, import needed, table inventory php script, inventory script php, brackets script, script import mysql file, inventory report mysql php, brackets php, inventory report php mysql, script inventory php, mysql file input format, script vba

About the Employer:
( 0 reviews )

Projektin tunnus: #1755094