PDF to text: How to parse text i) which appears afer semicolon in the same line and ii) is in all lines below until the new line with a semicolon arrives

(0) Share

Report

Posted on by PawelSlon

Hi Community, following question:

how to get in Power Automate Desktop the full address in case extraction from pdf to text gives following format:

The address of the entity is after the semicolon in line 4 and later goes through lines 6-8.

Ah - I am thinking about nice way of handling similar cases when the address would go A) through unspecified numer of lines farter down and/or B) will appear fully in line 5.

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@PawelSlon
You can use crop text to get your address if it have standard flags:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PawelSlon ,

Can you share the PDF ,so we can test that and provide a solution.
We are unable to replicate the issue.

Regards,
Vishnu Reddy

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Use Parse text with regular expressions enabled and the following regex pattern to retrieve it (assuming the address is always followed by a date): (?<=Address:\s).+(\r?\n.+)+?(?=\r?\nDate:).

Here's what the action should look like:

Then, if you want it in a single line, you can use Replace text to replace newlines with a whitespace:

Was this reply helpful? Yes No