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,
Solved! Go to Solution.
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.