regex101: JavaScript Substitution Workspace

Pro

REGEXP_REPLACEthe literal text REGEXP_REPLACE (case sensitive)

Group 1('RGM:NRKM:KMLPBC02 ADD TRANSPONDER','^.*([A-Z]{4}(VU|NT|MB|YT|WA|SK|CA|NF|PE|NB|NS|ON|IN|WI|IL|MI|MN|BC|PQ|CT|MA|NY|AB)[A-Z0-9]{2}).*$','$1','m')

'RGM:NRKM:KMLPBC02 ADD TRANSPONDER','the literal text 'RGM:NRKM:KMLPBC02 ADD TRANSPONDER',' (case sensitive)

^start of string

.*any character (except for line terminators), repeated any number of times

Group 2([A-Z]{4}(VU|NT|MB|YT|WA|SK|CA|NF|PE|NB|NS|ON|IN|WI|IL|MI|MN|BC|PQ|CT|MA|NY|AB)[A-Z0-9]{2})

Character Class[A-Z]{4}

{4}matches exactly 4 characters from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

Group 3(VU|NT|MB|YT|WA|SK|CA|NF|PE|NB|NS|ON|IN|WI|IL|MI|MN|BC|PQ|CT|MA|NY|AB)

1st AlternativeVU

VUthe literal text VU (case sensitive)

2nd AlternativeNT

NTthe literal text NT (case sensitive)

3rd AlternativeMB

MBthe literal text MB (case sensitive)

4th AlternativeYT

YTthe literal text YT (case sensitive)

5th AlternativeWA

WAthe literal text WA (case sensitive)

6th AlternativeSK

SKthe literal text SK (case sensitive)

7th AlternativeCA

CAthe literal text CA (case sensitive)

8th AlternativeNF

NFthe literal text NF (case sensitive)

9th AlternativePE

PEthe literal text PE (case sensitive)

10th AlternativeNB

NBthe literal text NB (case sensitive)

11th AlternativeNS

NSthe literal text NS (case sensitive)

12th AlternativeON

ONthe literal text ON (case sensitive)

13th AlternativeIN

INthe literal text IN (case sensitive)

14th AlternativeWI

WIthe literal text WI (case sensitive)

15th AlternativeIL

ILthe literal text IL (case sensitive)

16th AlternativeMI

MIthe literal text MI (case sensitive)

17th AlternativeMN

MNthe literal text MN (case sensitive)

18th AlternativeBC

BCthe literal text BC (case sensitive)

19th AlternativePQ

PQthe literal text PQ (case sensitive)

20th AlternativeCT

CTthe literal text CT (case sensitive)

21st AlternativeMA

MAthe literal text MA (case sensitive)

22nd AlternativeNY

23rd AlternativeAB

Character Class[A-Z0-9]{2}

.*any character (except for line terminators), repeated any number of times

$end of string

','the literal text ','

$end of string

1','m'the literal text 1','m' (case sensitive)

26 tokens

Regular Expression

REGEXP_REPLACE('RGM:NRKM:KMLPBC02 ADD TRANSPONDER','^.*([A-Z]{4}(VU|NT|MB|YT|WA|SK|CA|NF|PE|NB|NS|ON|IN|WI|IL|MI|MN|BC|PQ|CT|MA|NY|AB)[A-Z0-9]{2}).*$','$1','m')

New

|some=text1,text2|some=tex3,some=text3

Substitution

|some=text1,text2|some=tex3,some=text3