Import a text file and format the data into a google sheet.

Requirements for text file Processing

1) Given a text file formatted in a consistent fashion as in the file provided.
2) Import the data from the text file provided by the vendor and display it in a spreadsheet.
3) The data shall be organized into a table that puts the PO Number, Order Number, Ship Number, Item, Status Number, Lot Number, TRM, Date, and Update all into a row as shown below.
4)Each line shall be a different cell.
PO #
Order #
Ship #
Item #
Status #
Lot #
TRM
Date
Update


5) Each table shall contain the contents of the entire text file including the header information, but the header information may be displayed in any easy to read format at the top of the spreadsheet.
6) Each PO# Line represents one forklift and the total number of forklift trucks shall be counted and displayed in the header information along with the upload date.
7) A new tab shall be created every time that a new text file is processed.
8) The name of the tab shall be the date listed in the header of the text file.