Regex help needed

[Bhargav]

I have column with projects and want to extract required project from it using regex.

I need the output in following format.

Projects	Output
PRJ-19-000900243_54POS MCON socket housing pol B.mpp	PRJ-19-000900243
PRJ-19-000903451 D3200 With CPA_v2_200424.mpp	PRJ-19-000903451
PRJ-19-000903451 D3200 With ^&8_v2_200424.mpp	PRJ-19-000903451
PRJ-19-000903451 D3200 With 567_h2_20224.mpp	PRJ-19-000903451

[atcodedog05 · Accepted solution]

Hi @Bhargav 

Here is a workflow for the task.

Config:

(PRJ-[\w-]{12})

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Bhargav]

Hi atcodedog05,

You nailed it..

Thanks for the quick resolution.

[atcodedog05]

Happy to help 🙂 @Bhargav 

Cheers and Happy Analyzing 😀