Regex help needed

[mbrenn207]

Hi,

I need help with a Regex to extract the 10 digit string value located at the beginning of this string.  Note that not it will not always be in this format. There may be a __X__ or [X] in front of the string.  What can I use to extract this pattern?

Examples:

C-223-h003 Exclusion Of Mercury (Navsea) (Mar 2019)

__X__ D-223-g003 Contractor Obligations

(A) G-222-h004 Requirements of Subcontractors

Desired outcome:

C-223-hoo3

D-223-goo3

G-222-hoo4

[atcodedog05]

Hi @mbrenn207 

Here is the regex for the task. I am directly scanning for the required pattern.

(\w\-\d{3}\-\w\d{3})

Workflow:

Hope this helps : )