I have a process that reads a PDF to extract a data variable. The file is complex and was created by LIfeCycle Designer. Opening the file is slow and a performance drain so I would rather use a “Read PDF Text” activity and regex the text output if I can. The output from the Read PDF Text contains alot of text but the one value I am looking for is found where the row reads “SECTION I”. Then two rows below that I need the last data value (on the right) which is a login id. Is a regex possible to spot the row that starts with “Section I” and then go down 2 rows and pick the value on the right?
SECTION I
Request Type Request Date Current Loginid
Deactivate 03/30/21 iamauserid
A couple related points. The first 2 rows are always identical. Literally the only data that is unique is the date and loginid. Let me know if there is an option to parse like that.