regex101: PCRE2 (PHP) Match Workspace

Pro

Group 1(Exception:)

Exception:the literal text Exception: (case sensitive)

Negative Lookahead(?!.*\1)

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

\1the text saved by group 1

Group exception(?<exception>.+)

.+any character (except for line terminators), repeated at least once

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

\s+any whitespace character, repeated at least once

Jobthe literal text Job (case sensitive)

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

(Exception:)(?!.*\1)(?<exception>.+),\s+Job

New

Exception:100 : *** Error 3006 Logons are disabled., Job=ABC
Exception:XYZ API has failed. Exception: RDBMS error 2801: Duplicate unique prime key error, Job=ABC
Exception:100 : RDBMS error 2640: Specified table either does not exist in DEX or is moved to another map., Job=ABC

Extraction

Exception:100 : *** Error 3006 Logons are disabled., Job=ABC
Exception:XYZ API has failed. Exception: RDBMS error 2801: Duplicate unique prime key error, Job=ABC
Exception:100 : RDBMS error 2640: Specified table either does not exist in DEX or is moved to another map., Job=ABC