Hi
I want extract data from a vendor manual and I have specific key word list. Is there any way to automate read pdf file and write following out put to Excel?
- page no and line no that contains keyword
- extract the sentence that contains keyword
Hi
I want extract data from a vendor manual and I have specific key word list. Is there any way to automate read pdf file and write following out put to Excel?
Welcome to the forum
Read_PDF_WF.xaml (46.3 KB)
Here we go!
Split(pdfText,Environment.NewLine(0))(5) - This sentence means that I an splitting in lines and taking the fifth line.
*note that this factura variable is a string array
If you wanto to extract just some values you can find an index word in this case KW, ten characters after that specific words and taking 23 caractes of it.
Happy automation.
don’t forget to like us!
Thank you very much for your reply .
Thanks to you,
let us know if you need help, Don’t forget to mark the post as solved if your question was answered.
regards
why do i get this error ?
because you don’t have that activity installed
please goto:
and install
I would recomend to install all packages for now in order to test this solution, please install just this one and later you can install them all.
Look:
Don’t forget to like us
Happy automation.
All good. this solved the problem and had install Microsoft activity package as well. Thank you @beesheep
Amazing! its a pleasure to help, come back soon.
Don’t forget to like us
Happy Automation!
I get this error