regex101: Decision Table

Explanation

Pro

^start of line

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

cdtthe literal text cdt (case sensitive)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

Group 1([a-zA-Z_][a-zA-Z0-9_]{3,100})

Character Class[a-zA-Z_]

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

Character Class[a-zA-Z0-9_]{3,100}

{3,100}matches between 3 and 100 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Group 2([a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500})

Character Class[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}

{1,500}matches between 1 and 500 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

/the literal / (47₁₀ / 57₈ / 2F₁₆)

%the literal % (37₁₀ / 45₈ / 25₁₆)

&the literal & (38₁₀ / 46₈ / 26₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

^the literal ^ (94₁₀ / 136₈ / 5E₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

<the literal < (60₁₀ / 74₈ / 3C₁₆)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Group 3([a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500})

Character Class[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}

{1,500}matches between 1 and 500 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

/the literal / (47₁₀ / 57₈ / 2F₁₆)

%the literal % (37₁₀ / 45₈ / 25₁₆)

&the literal & (38₁₀ / 46₈ / 26₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

^the literal ^ (94₁₀ / 136₈ / 5E₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

<the literal < (60₁₀ / 74₈ / 3C₁₆)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

,?optionally matches the literal , (44₁₀ / 54₈ / 2C₁₆)

Group 4([a-zA-Z0-9_\- ]{1,100}=[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}(?:;[a-zA-Z0-9_\- ]{1,100}=[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500})*)?

?repeats the group contents below at most once:

Character Class[a-zA-Z0-9_\- ]{1,100}

{1,100}matches between 1 and 100 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Character Class[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}

{1,500}matches between 1 and 500 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

/the literal / (47₁₀ / 57₈ / 2F₁₆)

%the literal % (37₁₀ / 45₈ / 25₁₆)

&the literal & (38₁₀ / 46₈ / 26₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

^the literal ^ (94₁₀ / 136₈ / 5E₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

<the literal < (60₁₀ / 74₈ / 3C₁₆)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

Non-Capturing Group(?:;[a-zA-Z0-9_\- ]{1,100}=[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500})*

*repeats the group contents below any number of times:

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Character Class[a-zA-Z0-9_\- ]{1,100}

{1,100}matches between 1 and 100 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Character Class[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}

{1,500}matches between 1 and 500 characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

/the literal / (47₁₀ / 57₈ / 2F₁₆)

%the literal % (37₁₀ / 45₈ / 25₁₆)

&the literal & (38₁₀ / 46₈ / 26₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

^the literal ^ (94₁₀ / 136₈ / 5E₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

<the literal < (60₁₀ / 74₈ / 3C₁₆)

>the literal > (62₁₀ / 76₈ / 3E₁₆)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$the literal $ (36₁₀ / 44₈ / 24₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Quick Reference

27 tokens

Regular Expression

^\$cdt\[([a-zA-Z_][a-zA-Z0-9_]{3,100}),([a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}),([a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}),?([a-zA-Z0-9_\- ]{1,100}=[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500}(?:;[a-zA-Z0-9_\- ]{1,100}=[a-zA-Z0-9_+\-*/%&|^!=<>\[\]$ ]{1,500})*)?]$

$cdt[cdt1,$[col1]-4==1,$[col2]+$[col3],var1=1;var2=2+1;var3=6==6]
$cdt[cdt1,$[col1]-4==1,$[col2]+$[col3]]

Substitution

$cdt[cdt1,$[col1]-4==1,$[col2]+$[col3],var1=1;var2=2+1;var3=6==6]
$cdt[cdt1,$[col1]-4==1,$[col2]+$[col3]]