Extract Invoice Number from Email Subject for workflow

Help Studio
, , ,
1

Hi Everyone,

I want to extract the invoice number from email subject.

Email Subject:
Reply Requested: Bank Of India Corporation (BOIC High Grade Capital Markets 52103244HGPU)- Due By: 10/25/2025

I want to extract invoice number which will be floating: 52103244HGPU
Rest the email subject will be same

Thanks

2

Hi @Binod_Kumar_Biswal

Can you try the below

\d{8}[A-Z]{4}

The image shows a code editor with an expression that matches a pattern of 8 digits followed by 4 uppercase letters, applied to text which includes a message about a reply requested by the Bank of India Corporation with specific details including a code "52103244HGPU" and a due date of 10/25/2025. (Captioned by AI)
The image shows a code editor with an expression that matches a pattern of 8 digits followed by 4 uppercase letters, applied to text which includes a message about a reply requested by the Bank of India Corporation with specific details including a code "52103244HGPU" and a due date of 10/25/2025. (Captioned by AI)1433×472 20.3 KB

Or

(?<=Capital\s+Markets\s+)([0-9A-Z]+)

The image shows a regex search interface where the pattern is being tested, successfully matching the text "52103244HGPU" within a sample string. (Captioned by AI)
The image shows a regex search interface where the pattern is being tested, successfully matching the text "52103244HGPU" within a sample string. (Captioned by AI)1429×473 22.7 KB

Regards,

3

Hi @Binod_Kumar_Biswal

As you said the rest of subject will be the same, you may try this way.

emailSubject = “Reply Requested: Bank Of India Corporation (BOIC High Grade Capital Markets 52103244HGPU)- Due By: 10/25/2025”

startPosition = emailSubject.IndexOf(“Markets”) + “Markets”.Length + 1
invoiceNumber = emailSubject.Substring(startPosition, 12)

4

@Binod_Kumar_Biswal

you can try this

\w+(?=\)- Due By)

The image shows a regex (regular expression) testing interface with a highlighted pattern match in the test string, which appears to focus on extracting a sequence before 'Due By'. (Captioned by AI)
The image shows a regex (regular expression) testing interface with a highlighted pattern match in the test string, which appears to focus on extracting a sequence before 'Due By'. (Captioned by AI)931×387 18.6 KB

cheers

5

Hi @Binod_Kumar_Biswal

Try this Regex

(?<=Markets).*(?=\))

image
image655×232 14 KB

StrVar = System.Text.RegularExpressions.Regex.Match("YourStrInput","(?<=Markets).*(?=\))").ToString.Trim

Regards,
Gowtham K