Regular Expressions 101

1st Alternative(?:(?<!")(?:"")*"[^"]*(?:""[^"]*)*"|\w+!)(*SKIP)(*F)

Non-Capturing Group(?:(?<!")(?:"")*"[^"]*(?:""[^"]*)*"|\w+!)

1st Alternative(?<!")(?:"")*"[^"]*(?:""[^"]*)*"

Negative Lookbehind(?<!")

"the literal " (34₁₀ / 42₈ / 22₁₆)

Non-Capturing Group(?:"")*

*repeats the group contents below any number of times:

""the literal text ""

"the literal " (34₁₀ / 42₈ / 22₁₆)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

"the literal " (34₁₀ / 42₈ / 22₁₆)

Non-Capturing Group(?:""[^"]*)*

*repeats the group contents below any number of times:

""the literal text ""

Negated Character Class[^"]*

*matches any number of characters outside the set below:

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative\w+!

\w+any word character, repeated at least once

!the literal ! (33₁₀ / 41₈ / 21₁₆)

(*SKIP)acts like (*PRUNE), but the next unanchored match attempt starts where (*SKIP) was reached instead of at the next subject character

(*F)forces the current match attempt to fail at this position

2nd Alternative\b[A-Z]+\K\d+\b

\ban ASCII word boundary

Character Class[A-Z]+

+matches at least one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

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

\d+a digit, repeated at least once

\ban ASCII word boundary

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.

Search reference

Regular Expression

(?:(?<!")(?:"")*"[^"]*(?:""[^"]*)*"|\w+!)(*SKIP)(*F)|\b[A-Z]+\K\d+\b

New

SI(F5="";"";"Z_PACK_TYPE")
MARKET!A5
MARKET!MQ5
MARKET!AB5
MARKET!TX5
MARKET!SX5
MATMAS05!CZ5="3200";MARKET!DA5
SI(MATMAS05!CZ5="3200";MATMAS05!CZ5="3200";MARKET!DA5;"")
SI(L5="";"";"STRING")
SI(MATMAS05!CZ5="3300";MARKET!DA5;""
SI(ESTVIDE(MARKET!EG5);"";SI(MATMAS05!CZ5="3200";MARKET!EG5;"")

Regular Expression

Extraction