regex101: PCRE2 (PHP) Substitution Workspace

Non-Capturing Group(?: ([^";\r\n]*) #1 value without quotes or | \x20* ("(?:[^"]+|"")*") \x20* #2 value inside quotes )

1st Alternative ([^";\r\n]*) #1 value without quotes or

Group 1([^";\r\n]*)

Negated Character Class[^";\r\n]*

*matches any number of characters outside the set below:

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

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

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

Comment:1 value without quotes or

2nd Alternative \x20* ("(?:[^"]+|"")*") \x20* #2 value inside quotes

\x20*the literal (20₁₆ / 40₈ / 32₁₀) , repeated any number of times

Group 2("(?:[^"]+|"")*")

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

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

*repeats the group contents below any number of times:

1st Alternative[^"]+

Negated Character Class[^"]+

+matches at least one character outside the set below:

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

2nd Alternative""

""the literal text ""

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

\x20*the literal (20₁₆ / 40₈ / 32₁₀) , repeated any number of times

Comment:2 value inside quotes

Non-Capturing Group(?: (;) #3 values delimiter or | [\r\n]+ # rows delimiter )

1st Alternative (;) #3 values delimiter or

Group 3(;)

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

Comment:3 values delimiter or

2nd Alternative [\r\n]+ # rows delimiter

Character Class[\r\n]+

+matches at least one character from the set below:

\ra carriage return (ASCII 13)

\na line-feed (newline) character (ASCII 10)

Comment: rows delimiter

Global pattern flags

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

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

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

Search reference

Regular Expression

(?: ([^";\r\n]*)                   #1 value without quotes or
  | \x20* ("(?:[^"]+|"")*") \x20*  #2 value inside quotes
)
(?: (;)                            #3 values delimiter or
  | [\r\n]+                        #  rows delimiter
)

Test String
New

501 ; 8300000000000 ; ";Автономный ;"";округ""
  ""Ненецкий"";";test1
                      751;8600800000000; "  Автономный округ ""Ханты-Мансийский"", Район Советский" ;
                     1755;8700300000000;Автономный округ Чукотский, Район Билибинский
                     1725;7501900000000;Край Забайкальский, Район Петровск-Забайкальский

                  ;;
                       711;2302100000000;Край Краснодарский, Район Лабинский
                       729;2401600000000;Край Красноярский, Район Иланский
                       765;2700700000000;Край Хабаровский, Район Вяземский

Regular Expressions 101

Regular Expression

Test String
New

Extraction
Processing...

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...