Regex find

[Gorkem_Batuhan_MORKOC (Görkem Batuhan MORKOÇ)]

Hi;

I want to pull the expression between Regexle Amount and Subtotal.

Ouantity Item no. Description Unit Price Tax Amount
15 1011 Sprocket — Large 38.50 G 577.50
15 1010 Sprocket — Med 18.95 G 284.25
15 1009 Sprocket — Small 8.90 G 133.50
Subtotal 995.25

[Gokul001 (Gokul Balaji)]

Hi @Gorkem_Batuhan_MORKOC

Can you share Expected output

To get all the Values from Amount to Subtotal

Here is the regex expression

regex101: build, test, and debug regex

Regards
Gokul

[Gorkem_Batuhan_MORKOC (Görkem Batuhan MORKOÇ)]

Thank you very much Mr.Gokul

[Gokul001 (Gokul Balaji)]

Hi @Gorkem_Batuhan_MORKOC

Can you share the expected output

Regards
Gokul

[Gorkem_Batuhan_MORKOC (Görkem Batuhan MORKOÇ)]

15 1011 Sprocket — Large 38.50 G 577.50
15 1010 Sprocket — Med 18.95 G 284.25
15 1009 Sprocket — Small 8.90 G 133.50

[Gokul001 (Gokul Balaji)]

Hi @Gorkem_Batuhan_MORKOC

Use Assign Activity

LHS: Create an variable
RHS: System.Text.RegularExpression.Regex.Match(“Input String”,“(?s)(?<=Tax\sAmount\n)(.*?)(?=Subtotal)”).tostring

Here is the Regex expression

https://regex101.com/r/Zy5f3Q/1

For more Information refer the below regex

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

Regards
Gokul

[pravin_calvin (pravin kumar)]

Hi @Gorkem_Batuhan_MORKOC

if you need data as data table we can go with generate data table activity!

Regards

[ppr (Peter Preuss)]

for regex spanning over multiple line we do have to handle the \n as the dot (all chars) is excluding the line break. Have a look here:

if possible datatable parsing is recommended as well