Regular Expressions 101

Explanation

Pro

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

+repeats the group contents below at least once:

1st Alternative"[^"]*"

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

2nd Alternative[^;]

Negated Character Class[^;]

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

s modifier: single line. Allows a dot to match line terminators

Detailed match information will be displayed here automatically.

25 tokens

(?:"[^"]*"|[^;])+

New

_-₪* #,##0.00_-;-₪* #,##0.00_-;" ; asd"_-₪* "-"??_-;_-@_-

_-₪* #,##0.00_-;-₪* #,##0.00_-;" ; asd"_-₪* "-"??_-;_-@_-