regex101: PCRE (Legacy) Match Workspace

^start of line

Group datetime1(?<datetime1>\d+\/\d+\/\d+\s+\d+:\d+:\d+)

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field1(?<field1>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field2(?<field2>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field3(?<field3>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field4(?<field4>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field5(?<field5>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field6(?<field6>\d+)

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

Group field7(?<field7>\S+)

\S+any non-whitespace character, repeated at least once

\s+any whitespace character, repeated at least once

Group datetime2(?<datetime2>\d+-\d+-\d+\s+\d+:\d+:\d+)

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

\s+any whitespace character, repeated at least once

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

\d+a digit, repeated at least once

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

Search reference

Regular Expression

^(?<datetime1>\d+\/\d+\/\d+\s+\d+:\d+:\d+)\s+(?<field1>\d+)\s+(?<field2>\d+)\s+(?<field3>\d+)\s+(?<field4>\d+)\s+(?<field5>\d+)\s+(?<field6>\d+)\s+(?<field7>\S+)\s+(?<datetime2>\d+-\d+-\d+\s+\d+:\d+:\d+)

New

18/06/28 14:12:07 250  219561  711914   72864    0  784778 - 18-06-28 14:08:43

Regular Expressions 101

Regular Expression

Extraction