Regular Expressions 101

Explanation
Pro

Positive Lookbehind(?<="NULL","0","0","0",",","1",",)

"NULL","0","0","0",",","1",",the literal text "NULL","0","0","0",",","1",", (case sensitive)

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

+repeats the group contents below at least once:

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

Group 1([^"]+)

Negated Character Class[^"]+

+matches at least one character outside the set below:

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

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

Positive Lookahead(?=,"D\$")

,"Dthe literal text ,"D (case sensitive)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(?<="NULL","0","0","0",",","1",",)(?:"([^"]+)",?)+(?=,"D\$")

New

"apple","NULL","0","0","0",",","1",","fruit","red","sweet","D$","object"
"horse","NULL","0","0","0",",","1",","animal","large","tail","D$","object"
"Los Angeles","NULL","0","0","0",",","1",","city","California","smoggy","entertainment","D$","location"