This project involves going through a large number of text files and extract information and organise it in excel file. It is information about when the products were manufactured and delivered. It is about 380 files but probably half of them can be ignored.
These four properties should be in each record.
DEVICE ID (NID):
Production Date:
Program:
Delivery Date:
Product Type:
We have at two types of file that will provide information for each line in the excel file.
The Production log file will provide the following properties
• DEVICE ID (NID
• Production Date
• Program file
The Delivery log file will provide the following properties:
• DEVICE ID (NID)
• Delivery Date
• Product Type
I have provided some more info and some example files of the two types.