Hello,
I attempted to proceed with data extraction using the USE Application to extract table data from a PDF.
While the first attempt yielded the desired data, the second attempt resulted in different values from the selected data in the extract table data.
PDFs are always changing.
Can you provide advice on why this is happening?
The assigned value is DT1.Rows(1).Item(1).ToString.
Thank you in advance for your response.
For pdf table extraction it is good to go with document underatanding and use form extractor or use ai centwr and train a model rather than using frontwnd and ui automation
Cheers
After Extracting data in the pdf by using Extract table data activity. Open the properties and copy the selectors in strict selector and clear the selectors in the fuzzy selector and paste the copied selectors.
Hope it helps!!
@Anil_G
Thank you for the response!
However, as I’m still a beginner, it’s difficult for me to comprehend.
Could you explain the code with a screenshot?
I sincerely apologize for any inconvenience.
@mkankatala
Thank you for the response!
However, as I’m still a beginner, it’s difficult for me to comprehend.
Could you explain the code with a screenshot?
I sincerely apologize for any inconvenience.
Okay @22222222asas
After indicated the table by using Extract Table data activity, open the properties panel of Extract table data activity, there is a option called Target, expand it.
You found a option called Strict selector and copy the text and clear.
There is another option called Fuzzy selector and paste the copied there.
After that there is option called Targeting methods select the fuzzy selector and uncheck the remining options.
Follow the above process and it will extract the datatable from pdf everytime.
Note : It’s not a best practice. As @Anil_G said you have to use document understanding to extract the datatable from pdf’s. Document understanding is one of the method to extract the data from structured and unstructured documents.
Hope you understand!!
@mkankatala
Thank you for the response!
I attempted to follow your advice, but there is no text in the Strict Selector. Could you please provide a solution for this issue?
You are expanding Target(Next button) option I told you to expand the Target option which is at the top of it… @22222222asas
Hope you understand!!
@mkankatala
Thank you for your response!
It seems I may have misunderstood. Thank you for clarifying!
It’s my pleasure… @22222222asas
Happy Automation!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.