Looking to harvest data within and the filenames/paths of a group of PDF files within 1 folder “A” and key into an excel table.
While iterating, I would like to use “launch application” to open the ‘item’, then use OCR to harvest data within the PDF
After keying the file name and data into excel table, the PDF file is then copied to folder “B” and the original file in folder “A” deleted.
However, there is an error in step 5.
Which I believe is due to an unexpected character ''
error message “Script1.groovy: 6: unexpected char: ‘’ @ line 6, column 59.”
How can I set the cell value to be the path of the file in excel?