"Log" files are generated by a PC application on demand.
These "log" files are text data and have one row per carriage return. The data in each row has a mixture of separators. Sometimes separator is a space, a dash or brackets. (Examples attached)
The task is to create an excel spreadsheet (version 2007) which can parse through the external log files and create a formatted spreadsheet result.
Programmer will create the code to parse both of the attached "log" files into separate spreadsheet tabs.
We expect that the parsing logic will be programmed in Visual Basic however, the user will NOT be a VB programmer. There will need to be a cover page with cells and buttons that act as a user interface.
User should be able to select one log file or the other to import/parse or both. User should be able to paste the log file address into a cell on the cover page.
Hi, I have a lot of examples of text file parsing and management using excel I can send for demo. Already developed excel spreadsheets with front page, customization and more.
Please read your PMB for other info.
Thank you, Anto