regex101: PCRE2 (PHP) Match Workspace

^start of line

Group 1([^\|]*\|){19}

{19}repeats the group contents below exactly 19 times:

Negated Character Class[^\|]*

*matches any number of characters outside the set below:

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

Group OldType(?<OldType>[^\~]*)

Negated Character Class[^\~]*

*matches any number of characters outside the set below:

\~the literal ~ (126₁₀ / 176₈ / 7E₁₆)

Group NewType(?<NewType>[^\|]*)

Negated Character Class[^\|]*

*matches any number of characters outside the set below:

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

^([^\|]*\|){19}(?<OldType>[^\~]*)\~(?<NewType>[^\|]*)

Test String
New

Dec-28-2023|12:05:46,836|10.150.6.118|148:|some branch|uswer_name|d168a8b9-5647-421b-97ba-f2aa3bceb69a|1:Creation page stack|Success|action_portfolio_forms_c_save.action|8970:PORTFOLIO ONBOARDING - FORMS CAPTURE||3065254228||||||| ~newType|||
Dec-28-2023|12:05:46,836|10.150.6.118|148:|some branch|uswer_name|d168a8b9-5647-421b-97ba-f2aa3bceb69a|1:Creation page stack|Success|action_portfolio_forms_c_save.action|8970:PORTFOLIO ONBOARDING - FORMS CAPTURE||3065254228|||||||oldType~newType|||
Dec-28-2023|12:05:46,836|10.150.6.118|148:|some branch|uswer_name|d168a8b9-5647-421b-97ba-f2aa3bceb69a|1:Creation page stack|Success|action_portfolio_forms_c_save.action|8970:PORTFOLIO ONBOARDING - FORMS CAPTURE||3065254228||||||||||

Regular Expression

Test StringNew

Test String
New