Regex - PDF extraction

Help Activities
, ,
1

Hi, How to print the values from the pdf. Is there any substring/regex available to handle this?
pdf image

image
image852×231 3.46 KB

Extracted Text:
Insurance Companies
(Do not include group
policies)
Name of Insured
Cash Value /
To be Contract / Date
Amount of
replaced? Policy # of Issue
Coverage
111 Yes LI No
lil Yes E No
0 Yes 17 No
$ 0 0
$ 0 0
$ 0 0

Expected output:
image

2

Hi!

I would consider using other modes of extraction rather than just OCR and regex for this type of document.
Document Understanding - Introduction (uipath.com)
The check box is kinda problematic.

Either way:

Could you tweak the ocr-engine to output the rows as
111 Yes LI No $ 0 0
lil Yes E No $ 0 0
0 Yes 17 No $ 0 0
Instead of
111 Yes LI No
lil Yes E No
0 Yes 17 No
$ 0 0
$ 0 0
$ 0 0

If so you could use something like this:

(?m)^(.+?)\s+(.+?)\s+(.+?)\s+(.+?)\s+(.+?)\s+(.+?)\s+(.+?)$

use this site to help you understand the regex regex101: build, test, and debug regex together with chatgpt.

3

@sven.wullum1 . Thanks for the response. We are not allowed to use document understanding. The only thing we are allowed to use either regular expressions /substring to extract the data from pdf.