Trying to Read PDF with Blank Fields - Returns Field Name Instead

Help Studio
, , , ,
1

I have a robot that is extracting a PDF form and pasting the data into Excel. I am using the Use Application/Browser Activity and selecting all the fields one by one, assigning a variable and then Write Cell to write that variable to a cell in Excel.

When I select a blank field in the PDF, it will paste the Field Name instead of just leaving it blank.

How can I get the robot to just paste a blank/null value or skip it if it is blank?

screenshot
screenshot462×615 23.7 KB

2

Hi,

Check your selectors, highlit it.

Thanks

3

I’m not sure what setting i would need to change. Any hints?

screenshot 2
screenshot 2777×724 111 KB

4

@Jibraan_Uddin

Try to use a strict selector

Also for pdf it is not a good idea to use ui…instead we go with read pdf text and then use string manipulations or regular expressions

Cheers

5

Strict Selector does not work. I get the same results