regex101: PCRE (Legacy) Match Workspace

Pro

\ban ASCII word boundary

Date:the literal text Date: (case sensitive)

\h+any horizontal whitespace character, repeated at least once

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

\d{4}a digit, repeated exactly 4 times

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

Non-Capturing Group(?:1[0-2]|0?[1-9])

1st Alternative1[0-2]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

Character Class[0-2]

0-2one character from 0 (48₁₀) to 2 (50₁₀)

2nd Alternative0?[1-9]

0?optionally matches the literal 0 (48₁₀ / 60₈ / 30₁₆)

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

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

Non-Capturing Group(?:3[01]|[12][0-9]|0?[1-9])

1st Alternative3[01]

3the literal 3 (51₁₀ / 63₈ / 33₁₆)

Character Class[01]

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

2nd Alternative[12][0-9]

Character Class[12]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

Character Class[0-9]

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

3rd Alternative0?[1-9]

0?optionally matches the literal 0 (48₁₀ / 60₈ / 30₁₆)

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

\h+any horizontal whitespace character, repeated at least once

Non-Capturing Group(?:2[0-3]|[01]?[0-9])

1st Alternative2[0-3]

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

Character Class[0-3]

0-3one character from 0 (48₁₀) to 3 (51₁₀)

2nd Alternative[01]?[0-9]

Character Class[01]?

?matches at most one character from the set below:

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

Character Class[0-9]

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

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[0-5]?

?matches at most one character from the set below:

0-5one character from 0 (48₁₀) to 5 (53₁₀)

Character Class[0-9]

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

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[0-5]?

?matches at most one character from the set below:

0-5one character from 0 (48₁₀) to 5 (53₁₀)

Character Class[0-9]

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

$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

25 tokens

Regular Expression

\bDate:\h+\K\d{4}-(?:1[0-2]|0?[1-9])-(?:3[01]|[12][0-9]|0?[1-9])\h+(?:2[0-3]|[01]?[0-9]):[0-5]?[0-9]:[0-5]?[0-9]$

New

ServerName: (DESCRIPTION=(CONNECT_TIMEOUT=60)(RETRY_COUNT=5)(ADDRESS=(PROTOCOL=TCP)(HOST=xbian.dbaas.ing.net)(PORT=121))(CONNECT_DATA=(SERVER=DEDI)(SERVICE_NAME=pmx0))) ServerType: Oracle DatabaseName: MX_FN_OWNER RDBMSAccess: NATIVE_OCI ConnectionName: Mx0_MUXFO_1_1 ConnectionNo: 1  Date: 2020-03-29 08:58:10
insert into MX_FN_OWNER.TRN_EDBF (TIMESTAMP,M_IDENTITY,M_REFERENCE,M_USER,M_GROUP,M_DESK,M_DATE_SYS,M_DATE_CMP,M_TIME_CMP,M_SDATE_CMP,M_STIME_CMP,M_COMMENT,M_ERROR,M_START_END,M_TIME_CPU,M_TIME_SYB,M_TIME_ELAP,M_SCRPT_NAME,M_UNIT_NAME,M_ERR_COUNT,M_NPID) values (0,TRN_EODA_DBFS.nextval,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19) (Bulk_Copy begin, 19 columns, 1 Flush size)

                              ==============================================
ServerName: (DESCRIPTION=(CONNECT_TIMEOUT=60)(RETRY_COUNT=5)(ADDRESS=(PROTOCOL=TCP)(HOST=xb305-scan.net)(PORT=121))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=pmx02fn))) ServerType: Oracle DatabaseName: MX_FN_OWNER RDBMSAccess: NATIVE_OCI ConnectionName: Mx0_MXFO_168991_1 ConnectionNo: 1  Date: 2020-03-29 09:21:10
Mux execution time: 00:00:00   3 ms

Extraction

ServerName: (DESCRIPTION=(CONNECT_TIMEOUT=60)(RETRY_COUNT=5)(ADDRESS=(PROTOCOL=TCP)(HOST=xbian.dbaas.ing.net)(PORT=121))(CONNECT_DATA=(SERVER=DEDI)(SERVICE_NAME=pmx0))) ServerType: Oracle DatabaseName: MX_FN_OWNER RDBMSAccess: NATIVE_OCI ConnectionName: Mx0_MUXFO_1_1 ConnectionNo: 1  Date: 2020-03-29 08:58:10
insert into MX_FN_OWNER.TRN_EDBF (TIMESTAMP,M_IDENTITY,M_REFERENCE,M_USER,M_GROUP,M_DESK,M_DATE_SYS,M_DATE_CMP,M_TIME_CMP,M_SDATE_CMP,M_STIME_CMP,M_COMMENT,M_ERROR,M_START_END,M_TIME_CPU,M_TIME_SYB,M_TIME_ELAP,M_SCRPT_NAME,M_UNIT_NAME,M_ERR_COUNT,M_NPID) values (0,TRN_EODA_DBFS.nextval,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19) (Bulk_Copy begin, 19 columns, 1 Flush size)

                              ==============================================
ServerName: (DESCRIPTION=(CONNECT_TIMEOUT=60)(RETRY_COUNT=5)(ADDRESS=(PROTOCOL=TCP)(HOST=xb305-scan.net)(PORT=121))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=pmx02fn))) ServerType: Oracle DatabaseName: MX_FN_OWNER RDBMSAccess: NATIVE_OCI ConnectionName: Mx0_MXFO_168991_1 ConnectionNo: 1  Date: 2020-03-29 09:21:10
Mux execution time: 00:00:00   3 ms