Regular Expressions 101

Group 1(\w+)

\w+any word character, repeated at least once

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

Group 2(.*?)

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

Positive Lookahead(?=\s+[a-zA-Z]\w+:|$)

1st Alternative\s+[a-zA-Z]\w+:

\s+any whitespace character, repeated at least once

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)

\w+any word character, repeated at least once

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

2nd Alternative$

$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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(\w+):(.*?)(?=\s+[a-zA-Z]\w+:|$)

New

 event_time:2019-06-12 12:24:21.8542963 sequence_number:1 action_id:CR succeeded:true is_column_permission:false session_id:59 server_principal_id:2(...)

Regular Expression

Substitution