Regular Expressions 101

Pro

Non-Capturing Group(?:^.+?\(|,)

1st Alternative^.+?\(

^start of line

.+?any character (except for line terminators), repeated at least once

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

2nd Alternative,

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

Non-Capturing Group(?:\K[\w ]+(?:$[\S].*?$)?)

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

Character Class[\w ]+

+matches at least one character from the set below:

\wany word character

the literal (32₁₀ / 40₈ / 20₁₆)

Non-Capturing Group(?:$[\S].*?$)?

?repeats the group contents below at most once:

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

Character Class[\S]

\Sany non-whitespace character

.*?any character (except for line terminators), repeated any number of times

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

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.

25 tokens

(?:^.+?\(|,)(?:\K[\w ]+(?:\([\S].*?\))?)

New

CREATE TABLE notes(id INTEGER,code DECIMAL (4,2),PRIMARY KEY (id))
CREATE TABLE notes(id INTEGER,code TEXT)

CREATE TABLE notes(id INTEGER,code DECIMAL (4,2),PRIMARY KEY (id))
CREATE TABLE notes(id INTEGER,code TEXT)