Regular Expressions 101

Non-Capturing Group(?:sum\(|count\(|avg\()

1st Alternativesum\(

sumthe literal text sum (case sensitive)

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

2nd Alternativecount\(

countthe literal text count (case sensitive)

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

3rd Alternativeavg\(

avgthe literal text avg (case sensitive)

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

Group 1([\w|(|_|+|\-|*|\/|.|'|[|\]|||]*)

Character Class[\w|(|_|+|\-|*|\/|.|'|[|\]|||]*

*matches any number of characters from the set below:

\wany word character

|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

No unit tests · Add a test to get started

Search reference

Regular Expression

(?:sum\(|count\(|avg\()([\w|(|_|+|\-|*|\/|.|'|[|\]|||]*)

There are no unit tests, click to add some.