Extracting two digits after an specific character with Regex

[VahidGoli]

Hi All,

I have these strings:
RIG09_ Tghkj_C_2:1
SdTG_RIG09_bBRF_C_2:1

I want a formula to generate Rig 09 for both strings.

So actually I want to get two digits after the word RIG in any string and just Rig+two digits.

Would you please help me out?

Kind regards,

[Sebastiaandb · Accepted solution]

Hi @VahidGoli ,

This might be it :-):

(.*)(RIG)(\d{2})(.*)

and then take group 3.

Greetings,

Seb

[DataNath]

RegEx tool > Parse mode, with the following expression:

(RIG\d{2})

No need for the additional groups if you’re only interested in this part.