Regular Expressions 101

^start of line

Negative Lookahead(?!(?:\\.|[^"]|"(?:\\.|(?!test)[^"])*")*$)

Non-Capturing Group(?:\\.|[^"]|"(?:\\.|(?!test)[^"])*")*

*repeats the group contents below any number of times:

1st Alternative\\.

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

.any character (except for line terminators)

2nd Alternative[^"]

Negated Character Class[^"]

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

3rd Alternative"(?:\\.|(?!test)[^"])*"

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

Non-Capturing Group(?:\\.|(?!test)[^"])*

*repeats the group contents below any number of times:

1st Alternative\\.

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

.any character (except for line terminators)

2nd Alternative(?!test)[^"]

Negative Lookahead(?!test)

testthe literal text test (case sensitive)

Negated Character Class[^"]

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

$end of line

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

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.

Search reference

Regular Expression

^(?!(?:\\.|[^"]|"(?:\\.|(?!test)[^"])*")*$).*

New

dim a as string = " test"  ( test should be detected)
dim a as string = "abc  test xyz"  ( test should be detected)
dim test as string = "abc"  ( test should not be detected)
dim str as string = "select id from " & test & "where place" (test should not be detected)