Need a Regex for string

[Puneet_Singh1 (Puneet Singh)]

I am getting below types of string.

Change order number 1 has been processed for Work Request 06333923

Item Job GEO LOC Bid Area FRC Quantity Status

---

CHR100 MRHV9C ZX162M WAZ3 219M 1.00 DISAPPROVED
HVR100 MRHV9C ZX162M WAZ3 219M 0.00 DISAPPROVED

Disapproval Reason: NO PHOTOS IN MDAT

---

Change order number 1 has been processed for Work Request 06297746

Item Job GEO LOC Bid Area FRC Quantity Status

---

GENDP MRGN18C ZX127V WLA5 219M 1.00 APPROVED
GNMTRL MRGN18C ZX127V WLA5 219M 32.66 APPROVED
GNRFD MRGN18C ZX127V WLA5 219M 12.00 APPROVED
LSPRTD MRGN18C ZX127V WLA5 219M 4,407.60 APPROVED

Disapproval Reason:

Above are 2 different type of string. In some email we got approved and in some disapproved.
in case of disapproved we also need to get the reason.

How we use regex please share example.

[vrdabberu (Varunraj Dabberu)]

Hi @Puneet_Singh1

Workflow:

xaml:
Main.xaml (10.2 KB)

Check out the below output:

Regards

[ppr (Peter Preuss)]

Maybe the following will work:

when match is empty - approved
when match is not empty - not approved and value is the reason:

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

[pikorpa (Piotr Kołakowski)]

Hey @Puneet_Singh1
here you will find a solution that groups item numbers and, in the case of disapproved status, adds a reason to the datatable:
BlankProcess84.zip (3.9 KB)
.
You can add necessary elements from any line, depending on your needs: