Which regex expression pattern to use if I want to select the number after 2 words?

[Steven_McKeering]

Hi @mce

Thank you for the Sample, the expected Output. But I think we need more information on the Pattern and any extra requirements you have.

There are many talented people on the UiPath Community forums who can help with a pattern and have contributed a reply (@ppr and @Gokul001) but they need as much information as possible to make a strong pattern This information should be in the first post.

1 Minute invested in Original Post = 2+ Minutes saved later

From your subsequent information/questions I have created two patterns which may suit. These patterns both rely heavily on the text “P&OCrew/” and slashes “/”.

Your Information / Requirements are:

@mce

I want to select the number only of the below text?

@mce

How can I skip the 2nd word in the expression?

@mce

and I have always the denomination "P&OCrew/
and then the initial always change it can be LBS/ or MCCC/ or MI/

Providing confirmation that “P&OCrew/” is a constant is valuable information.
I have assumed that there is more than three variants and not just “LBS” or “MCCC” or “MI”.

My Patterns
Pattern #1 - Preview it here

This pattern relies on Letters only (A-Z or a-z) in the second part of the expression.

Pattern #2 - Preview it here

This pattern is a little more dynamic but can handle no second grouping or “word”.

If you want to learn Regex - check out my Regex MegaPost.

Hopefully you have found a suitable pattern from the above replies.

Cheers

Steve