Table Extraction from pdf using sap irpa 2.O

[former_member693923]

HI ,
I am trying to extract table column entries from pdf in cloud studio using activity named 'get table column entries'. but getting the error not found.
Can anyone please help me in resolving this issue.

Thanks in advance

Sujata pdf.pngworkflow.pngoutput.png

[Chaitanya_Priya · Accepted solution]

Hi sujata_jena15,

Please provide the left offset and Rightoffset values to retrieve the data.

Attached are the screenshots for ur reference.

[former_member693923 · Accepted solution]

Hi Chaitanya Priya Puvada,

Thank you for the response.

Can you please explain how you are calculating left offset or right offset for 'get table column entries' .

Thanks in Advance,

Sujata Jena

[Chaitanya_Priya · Accepted solution]

Hi Sujata,

I have searched for the string Items (which is above of my table in the PDF) using the activity Search Text Items .

In the output ,I have taken the left value and took the same offset as reference in Get Table Column entries Activity

[former_member693923 · Accepted solution]

Hi Priya,

Thank you for explanation. I tried your suggested approach and able to extract the contents of first column.

Can you please confirm once that for the rest columns do we need to search for the left offset of previous column header ?

Thanks in Advance

Sujata

[Chaitanya_Priya · Accepted solution]

For more details,Please refer to this blog post which was published yesterday by my team member .

SAP Intelligent RPA 2.0 – How to read table column data in PDF | SAP Blogs

[chirdeeprastogi · Accepted solution]

hi @chaitanyapriya.puvvada

i have used Get element activity to get the text checkbox / P0123 but how do i get only number P0123 from the text.

Regards,

Bhagyashree