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.