I have a text file generated from an undocumented feature in MS Access which outputs an object's definition into a text file. There is a 'structure' to this text file, but it's mostly visual based on groups of space characters. So for each control on a form, there is a BEGIN and an END row that share the same indent level, and there are controls withon controls (think a button in a detail sections of a form, which is a subform, which is in a subform control on a main form...)
FORM>Subform Control>Subform>Detail Section>Button>myriad properties about the button...
For my purposes, I probably need less than 25% of the data in these file; I don't care about the size and locations of items, or any of their formatting properties. I just need to scrape out the meaty stuff like Rowsource, ControlSource, Name, Event Procedures, etc.
I have tried to do this on my own and got some good results based on ideas I learned from Gil Raviv's post
But I can't seem to figure out how to make it into usable data. Frankly, I think this might asking far too much of PQ.
The database I'm analyzing has well over 5,000 objects in it. It's been on life support for many years and I need to be able to disect it to begin replacing it. None of the paid or freeware tools are able to process this database which is why I have resorted to this option.
If anyone has some ideas on how to approach this, or can confirm that PQ isn't an appropriate tool for such a task, please chime in. I have provided links to the original text output file ( ContractReviewLog.txt ) as well as my work on it thus far ( MotherOfAlPQChallenge.xlsx ).
As always, I look forward to learning from all of you!
Thanks, Rich P
