Regex with multiple Condition !!

[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"

[UshaJyothi20]

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 

[mohan2mm]

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 ?

[UshaJyothi20]

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 

[Deenuji]

@mohan2mm 

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

[Deenuji]

@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 🚀

[mohan2mm]

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"

[UshaJyothi20]

@mohan2mm 

Try this the regex pattern is  

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

Hope this helps

Usha

[mohan2mm]

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.

[Deenuji · Accepted solution]

@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 🚀

[eetuRobo · Accepted solution]

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.

[mohan2mm]

My other requirement is from the below details would like to copy the text above "Total Amount Due" However I need only the highlighted portion in dynamic way considering all the examples

[Deenuji]

@mohan2mm 

It seems like you have several requirements within the same use case, and members of the community are offering various solutions and suggestions for your different requirement raised in the thread. It's likely that many of your requirements have already received answers. Therefore, please mark the appropriate responses as solutions. I'll address the requirement you mentioned above and provide my suggestions soon.

[Deenuji]

@mohan2mm 

Please use the below .Net script for the same.

Flow screenshot:

Code:

SET PDFEXTRACT TO $'''Viesh Dhpani
+98272389727398273
1 ADC BBB e-Travel cost May\'23 - 2,000.00
Total amount Due:2,000.00 EUR
Amount in Words: Two Thousand Euro

Viesh Dhpani
+98272389727398273
2 ADC BBB e-Travel cost June-23 - 2,000.00
Total amount Due:2,000.00 EUR
Amount in Words: Two Thousand Euro

Viesh Dhpani
+98272389727398273
2 Thi is my cost December-2023 - 2,000.00
Total amount Due:2,000.00 EUR
Amount in Words: Two Thousand Euro'''
Variables.CreateNewList List=> extractedValues
Scripting.RunDotNetScript Imports: $'''System.Text.RegularExpressions''' Language: System.DotNetActionLanguageType.CSharp Script: $''' // Define the regex pattern to match the desired values
 string pattern = @\"(.*?)(?=\\nTotal amount)\";

 // Match the pattern in the input text
 MatchCollection matches = Regex.Matches(inputText, pattern, RegexOptions.Multiline);

 // Extract and process the matched values
  extractedValues = new List<string>();
 foreach (Match match in matches)
 {
     string matchedText = match.Groups[1].Value.Trim();
     if (!string.IsNullOrEmpty(matchedText)) // Check if matched text is not null or empty
     {
        
         // Remove the value after month with year (e.g., \"May\'23\")
         string processedValue = Regex.Replace(matchedText, @\"\\s-\\s\\d+,\\d+\\.\\d+\", \"\");
         // Remove the first character
         if (processedValue.Length > 1)
         {
             processedValue = processedValue.Substring(2);
         }
         extractedValues.Add(processedValue.Trim());

     }
 }''' @'name:inputText': PDFEXTRACT @'type:inputText': $'''String''' @'direction:inputText': $'''In''' @'name:extractedValues': $'''''' @'type:extractedValues': $'''List''' @'direction:extractedValues': $'''Out''' @extractedValues=> extractedValues

How to copy/paste the above code into your Power automate desktop?

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 🚀

[mohan2mm]

Hi Deenuji - My apologies, if my requirement was not clear and appreciate all your support in helping.

I added your code and the results were blank. I have attached a Word document with the right scenarios.

Note for each scenario I have an IF condition in place i.e overall I have FOUR IF conditions and each results are stored in separate variables.

Please check the requirements and let me know if you need any more information.