Answered

Regex with multiple Condition !!

(0) Share

Report

Posted on by mohan2mm

Hello,

I'm looking to get the Regex if the extracted PDF consist of sentence "Line Description Net Billing" and to copy a line above "Total Amount Due:", The output I'm expecting is "Service rendered for Jul'22"

Categories:

Power Automate Desktop

I have the same question (0)

All responses (14)

Answers (2)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mohan2mm

@Try this

.*/n(?=Total Amount Due)

Then you will get the line above to the total amount due

Then split it by spaces according to the requirement.

Hope this helps

Usha

Was this reply helpful? Yes No
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Usha - Thanks for your response.

I want to make sure if "Total Amount Due:" is present as part of the extract, Is this something I can give if condition and use the regex to extract the value ?

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Then extract whole text by using

(?<Line Description Net Billing).*/n.*/n.*/n.*/n

How many lines you needed use the same number of /n

Then then the output will be stored in one variable

Then write if condition

Variable contains total amount due then do the process what you need...

Else......what you need to do...

By using the activities.

If my answer helps you please mark it as a solution and like it which keeps me motivated.

Thank you.

Hope this helps

Usha

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mohan2mm

Just add if contains and include your pdfextract variable and you can follow parse text and use regex which usha mentioned above.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mohan2mm

You can use the below approach which suits you more.

1. If condition we are checking both line description and total due are exists in pdfextract variable then parse the text using regex we are extracting service details.

Regex used: \b\d+ Service rendered for [A-Za-z]+'[0-9]{2} \d{1,3}(,\d{3})*\.\d{2}\b

2. Another approach is we are just checking whether pdfextract data is starts with "line description" then parse our text.

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
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deenuji - I have a couple of requirements in the same line.

1. What is the Regex to find the address which is in between "Start" & "End" OR "End1"

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mohan2mm

Try this the regex pattern is

(?<=Start:).*\n.*\n.*\n.*\n.*\n.*\n.*\n.*

Hope this helps

Usha

Was this reply helpful? Yes No
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Usha - My content could be more than 5 line items, which is not predictable, so want to consider "END" or "END1", so that the RegEx is more dyanmic.

Was this reply helpful? Yes No
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@mohan2mm

You can also consider crop text action for the same.

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
Verified answer

eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this: (?<=Start:)[\s\S]*?(?=End(?:1)?)

Should work with it ending both End1 and End

Tip: if you need to get Regex you could try asking free version of ChatGPT and using this regex tester site: http://regexstorm.net/tester
It usually gives wrong results at first but just tell it that it doesn't work and it gives you modified regex and usually after like 3-5 times of trying I get result that works. Also try giving it more info like that you are using Power Automate Desktop which uses regex with .NET engine and give it a sample of the text that the regex should work on.

Was this reply helpful? Yes No