Regular Expressions 101

Positive Lookbehind(?<=CREATE TABLE[^(]*\([^()]*)

CREATE TABLEthe literal text CREATE TABLE (case sensitive)

Negated Character Class[^(]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

Group 1([^"]*)

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

Global pattern flags

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

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

Detailed match information will be displayed here automatically.

26 tokens

Regular Expression

(?<=CREATE TABLE[^(]*\([^()]*)"([^"]*)"

New

CREATE TABLE "listings" (
        "listing_id"    INTEGER UNIQUE,
        "state" TEXT,
        "title" TEXT,
        "description"   TEXT,
        "price" TEXT,
        "currency_code" TEXT,
        "url"   TEXT,
        PRIMARY KEY("listing_id")

Regular Expression

Substitution