Regex to Extract Deal Id from Email Body

Help Studio
, ,
1

Hi Everyone,

I want to extract the deal code from email body where the body having a same pattern every time.

Input :
Example 1:
Hi,
Finance Information for ABC Inc (53481CRED). Could you review the attached deal.

Expected Output : 53481CRED

Example 2:
Hi,
Finance Information for ZSW Corporation (CARH 01ABRD). Could you review the attached deal.

Expected Output: CARH 01ABRD

Thanks in Advance

2

Hi @Binod_Kumar_Biswal

You can use this regex : ((.*?)) to extract the value using matches activity

The image shows a regular expression test in a code editor, highlighted as "/(.*? ?)/g", and applied to two text examples to extract content within parentheses, with expected outputs being highlighted next to the examples. (Captioned by AI)
The image shows a regular expression test in a code editor, highlighted as "/(.*? ?)/g", and applied to two text examples to extract content within parentheses, with expected outputs being highlighted next to the examples. (Captioned by AI)1413×519 35.5 KB

Regards
Naman Jain

3

Hi @Binod_Kumar_Biswal

Can you try this

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

The image shows a regular expression tool detecting and highlighting specific patterns within parentheses in a text, with two examples indicating the expected outputs: "53481CRED" and "CARH01ABRD." (Captioned by AI)
The image shows a regular expression tool detecting and highlighting specific patterns within parentheses in a text, with two examples indicating the expected outputs: "53481CRED" and "CARH01ABRD." (Captioned by AI)1430×523 37.1 KB

Regards,

4

Thanks for the reply but in mail body multiple deal id inside the braces for example

Input:
Hi ,
Finance Information for ABC Inc (53481CRED). Could you review tye attached deal to settle the (63471DEAL) for this month.

The Entire email body will have multiple deal codes but we need to extract tye deal id which is prior to Could you please review.
Expected Output: 53481CRED

5

@Binod_Kumar_Biswal

(?<=\()(.*?)(?=\))(?=.*Could you review)

The image shows a regular expression used to extract a deal ID from an email body example, with the highlighted match "(63471DEAL)" demonstrating its effectiveness. (Captioned by AI)
The image shows a regular expression used to extract a deal ID from an email body example, with the highlighted match "(63471DEAL)" demonstrating its effectiveness. (Captioned by AI)1434×525 33.4 KB

Regards,

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.