Regular Expressions 101

Group 1((?:(?!\band\b)[^'])*(?:'[^'\\]*(?:\\.[^'\\]*)*'(?:(?!\band\b)[^'])*)*)

Non-Capturing Group(?:(?!\band\b)[^'])*

*repeats the group contents below any number of times:

Negative Lookahead(?!\band\b)

\ba Unicode word boundary

andthe literal text and (case sensitive)

\ba Unicode word boundary

Negated Character Class[^']

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

Non-Capturing Group(?:'[^'\\]*(?:\\.[^'\\]*)*'(?:(?!\band\b)[^'])*)*

*repeats the group contents below any number of times:

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

Negated Character Class[^'\\]*

*matches any number of characters outside the set below:

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

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

Non-Capturing Group(?:\\.[^'\\]*)*

*repeats the group contents below any number of times:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

.any Unicode character (except for line terminators)

Negated Character Class[^'\\]*

*matches any number of characters outside the set below:

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

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

Non-Capturing Group(?:(?!\band\b)[^'])*

*repeats the group contents below any number of times:

Negative Lookahead(?!\band\b)

\ba Unicode word boundary

andthe literal text and (case sensitive)

\ba Unicode word boundary

Negated Character Class[^']

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

Non-Capturing Group(?:and|$)

1st Alternativeand

andthe literal text and (case sensitive)

2nd Alternative$

$end of string, or before its final line terminator

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

((?:(?!\band\b)[^'])*(?:'[^'\\]*(?:\\.[^'\\]*)*'(?:(?!\band\b)[^'])*)*)(?:and|$)

New

section_category_name = 'computer and equipment expense' and date >= 2015-01-01 and date <= 2015-03-31