Extract string data from text using regex

[Mohamed_Abodonia]

07/16/2021 22:32:06 => [Debug] Debug started for file: ExtractPDFdataRegex
07/16/2021 22:32:08 => [Info] Process_Vendor_Invoices_Performer_Project execution started
07/16/2021 22:32:09 => [Debug] Invoice No. 216060 Bulevardul Papetariei 57
Bucuresti, Romania
Date: 2017-07-13

Vendor: Office Supplies

Client Name

ACME Systems Inc.

Somewhere Road 59,

Bucharest, Romania

Notes

Invoices must be paid within 20 days starting with the issue date.

Item Description Quantity Price Per Total

Various paper supplies 1 269033 USD 269033 USD

Subtotal: 224194 USD

Tax: 44838.8 USD

Total: 269033 USD
07/16/2021 22:32:09 => [Info] Process_Vendor_Invoices_Performer_Project execution ended in: 00:00:01

I have a piece of text like that and I just want only to extract (Various paper supplies) using regex as this string dynamically changes but its position fixed

[prasath17 (Guru)]

@Mohamed_Abodonia - looks like(Duplicate) below post has the same thing …

Regex Extraction Text

@Mohamed_Hassan1 - Please check this… [image] StrDescrption = System.text.regularexpressions.regex.matches(yourtext,"?<=Total\r?\n)(.+)\s+\d+\s+\d+\s+([A-z]{3})")(0).groups(1).tostring Strcurrency = System.text.regularexpressions.regex.matches(yourtext,"?<=Total\r?\n)(.+)\s+\d+\s+\d+\s+([A-z]{3})")(0).groups(2).tostring For your reference Hope this helps…

[prasath17 (Guru)]

@Mohamed_Abodonia

Item Description Quantity Price Per Total

Various paper supplies 1 269033 USD 269033 USD

In the above post…there were no spaces after the given text…here there are spaces…

so adjusted code as below…use this as shown in the above post…this will work…

  (?<=Total\r?\n\r?\n?)(.+)\s+\d+\s+\d+\s+([A-z]{3})

regex101: build, test, and debug regex

[Mohamed_Abodonia]

it doesn’t return the output string

[Mohamed_Abodonia]

[prasath17 (Guru)]

@Mohamed_Abodonia -I can see 2 spaces before your regex pattern… please look closely…just copy paste from the link I provided above…

If you are building the datatable variable like this…then what I gave won’t work…

Use the below one for Description

regex101: build, test, and debug regex

Currency - use the below one…

regex101: build, test, and debug regex

[Mohamed_Abodonia]

Thank you so much <3 final question how can i exctract only total not subtotal

Subtotal: 224194 USD
Tax: 44838.8 USD
Total: 269033 USD

[prasath17 (Guru)]

@Mohamed_Abodonia - Please check this…

Note: You should uncheck the ignore case if you are using “Matches” activity…

[Mohamed_Abodonia]

Thank you so much