Copy Text From Multiple PDF Into a New Numbers Spreadsheet

[tiffle]

@HMayes

AH! I just tried this on three other invoices, and they all worked. I think maybe when using the redact tool in preview it does this to prevent copying any info from the document.

That makes a lot of sense - if you could "read" the text under the redaction it wouldn't be much use!

OK - I suggest you look at post #1 in this discussion

Keyboard Maestro “Convert PDF Files into Text Files in the Front Finder Window” Macro

Edited 2022-08-21 to bring installation information up to date. -ccs Hey Folks, I've posted a number of times in various threads about the Xpdf command-line tools – particularly about the pdftotext tool. Download Xpdf and XpdfReader Look for the “Mac 64-bit” version in the “Download the Xpdf command line tools” section. The utilities contained in the Xpdf downloadable binary are: pdfdetach pdffonts pdfimages pdfinfo pdftohtml pdftopng pdftoppm pdftops pdftotext Installation Instruction…

which basically tells you how to extract the text from one pdf and then extend that to cover many pdfs in a folder.

Once you've got that working you need to find a way to

1. Extract the 2nd line following "Bill To" to get "XXX CLIENT NAME 2XXX"
2. Extract the 2nd dollar amount from the last line to get "110.25" (or whatever is there)

Personally, I would use the Search Using Regular Expression action to perform the extraction - but there are many other ways; a search of the KM forum will turn up many examples of the use of regular expressions and scripting.

Can't be of more help right now - it's bedtime!