Please see the attached image file that shows (3) versions of extracted text from a PDF using Power Automate desktop.
At this time I'm using a method on a about 25 pieces of content by using the parse and get subtext based on logic between the starting position of the "Before" text and the Starting Position of "After" text to then extract specific text.
I want the highlighted content in each image - "date at time"
So using my aforementioned approach the "Before" text I look for is "SUBMITTED " and the AFTER text I look for is "REPORTED SOURCE " - then I use the GetSubtext for the exact amount of characters for the "date at time" - which is 22 characters.
The issue - is that sometimes the "date at time" content crosses over to another line and the number of characters to extract changes randomly - and - it's retrieving the Line Break?
So for each image the result of the GetSubtext is:
(1) 02/24/2023 at 02:10 PM
(2) 02/14/2023 at 02:47 P
M
(3) 02/15/2023 at
12:1
I’m using Power Automate DESKTOP
So I was thinking an approach may be to *Remove LINE BREAKS from the temporary TXT file and then the number of characters will NOT vary and I won't retrieve the line break. (* - couldn't figure that out)
I'd appreciate any help!
