I have an influx of reports coming at me, and I need to extract some of the data and put it into a better format(an excel worksheet.) The reports come in docx or pdf and look something like this.
Miscellaneous data...................
Unneeded data.......
North South West
Name Lakeview Church Lakeview Church
Making Brick Wood
Status Gone "small checkmark"
unneeded data.......
Name Baxter Building Baxter Building
Making Brick Brick
Making Gone Great
But, the text isn't all in tables. Some are, some are just in appropriately placed text boxes.
I'm kinda going out on a limb here, but I was hoping there would be something that allowed me to make some sort of template that extracted the appropriate data and re organized it something like this:
Name Direction Making Status
Lakeview Church North Brick Gone
Lakeview Church South Wood Good
Also, there are some small images in the reports. I don't need to extract the images, but if they could be translated into something to show an image was present it would be great. And, if I could tell it to do things like ignoring all things with "Church" in the name on the North side, it would be perfect.