regex101: DB2 Nodes improved

Character Class[0-9]+

+matches at least one character from the set below:

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

Character Class[ \t\r]+

+matches at least one character from the set below:

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

\ta tab character (ASCII 9)

\ra carriage return (ASCII 13)

Group 1(\w|\.|\-)+

+repeats the group contents below at least once:

1st Alternative\w

\wany word character

2nd Alternative\.

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

3rd Alternative\-

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

Character Class[ \t\r]+

+matches at least one character from the set below:

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

\ta tab character (ASCII 9)

\ra carriage return (ASCII 13)

Character Class[0-9]+

+matches at least one character from the set below:

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

Group 2([ \t\r]+(\w|\.|\-)+[ \t\r]+\-[ \t\r]+\w+|)

1st Alternative[ \t\r]+(\w|\.|\-)+[ \t\r]+\-[ \t\r]+\w+

Character Class[ \t\r]+

+matches at least one character from the set below:

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

\ta tab character (ASCII 9)

\ra carriage return (ASCII 13)

Group 3(\w|\.|\-)+

+repeats the group contents below at least once:

1st Alternative\w

\wany word character

2nd Alternative\.

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

3rd Alternative\-

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

Character Class[ \t\r]+

+matches at least one character from the set below:

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

\ta tab character (ASCII 9)

\ra carriage return (ASCII 13)

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

Character Class[ \t\r]+

+matches at least one character from the set below:

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

\ta tab character (ASCII 9)

\ra carriage return (ASCII 13)

\w+any word character, repeated at least once

2nd Alternative — matches an empty string

Group 4(\n|\r|)+

+repeats the group contents below at least once:

1st Alternative\n

\na line-feed (newline) character (ASCII 10)

2nd Alternative\r

\ra carriage return (ASCII 13)

3rd Alternative — matches an empty string

Global pattern flags

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

Search reference

Regular Expression

[0-9]+[ \t\r]+(\w|\.|\-)+[ \t\r]+[0-9]+([ \t\r]+(\w|\.|\-)+[ \t\r]+\-[ \t\r]+\w+|)(\n|\r|)+

Test String
New

0 coralxib42 0 coralxib42-ib0 - MEMBER
1 coralxib43 0 coralxib43-ib0 - MEMBER
128 coralxib44 0 coralxib44-ib0 - CF
129 coralxib45 0 coralxib45-ib0 - CF
0 coralpib241 0 - - MEMBER
1 coralpib242 0 - - MEMBER
128 coralpib243 0 - - CF
129 coralpib244 0 - - CF
cskd;ksd ksalkd;lksakd sad'lj
020 - 29 
0 coralpib241 0
1 coralpib242 0
128 coralpib243 0
129 coralpib244 0

Regular Expressions 101

Regular Expression

Test String
New

Substitution
Processing...

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...