Read pdf and extract data with required column

Learning Initatives Automation Starter
1

Hi All,

I have used read pdf acitivity for reading a pdf and i have extracted the required data sucessfully. But encountered with a different scenario where the extracted column data is blank. bot is picking up the data before the required column. Not sure, how to solve this

Example:
Benefit Amt, Approved amt
10 ,

2

Hi @pramod1

Could you share the screenshot of the table in the PDF.

Try Reading the PDF text by setting the PreserveFormatting property to True.

Then you can figure out how to use the spacing to differentiate between the columns

3

image

Here, based on Benefit Estimated i will proceed with further processing. Sometimes, i see there is no data and it is blank. So, when BE is blank then bot is picking up the patient responsibility column data which is incorrect. I need to proceed with BE column data with or without data in it.