Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
^(?:[^"'\n]*(?:"(?:[^"\n]|"")*"))*[^']*('(?:_\n|.)*)
/
gm
Input 1
1
New
ewr "Having ""quoted"" quotes couldn't work, could they"? "Yeah, they do!" 'Great Working - This is a test 'This should be captured Working - "this is a test" 'This should be captured Not Working - "this is a test" 'This should be "captured" Not Working - This is a test 'This should be "captured" Working - "this is a test 'this should not capture'" 'this should capture Working - "this isn't a test" 'this should capture 'Comment with a line _ continuation Debug.Print 'End of line comment _ with line continuation. Debug.Print 42 'The next line... _ "...is not a string literal" Debug.Print "Unmatched double quotes." 'Comment" Debug.Print "Interleaved single 'n double quotes." 'Comment" 'No comments or strings in the line below. Debug.Print [Evil:""Comment"'here]
Extraction
ewr "Having ""quoted"" quotes couldn't work, could they"? "Yeah, they do!" 'Great Working - This is a test 'This should be captured Working - "this is a test" 'This should be captured Not Working - "this is a test" 'This should be "captured" Not Working - This is a test 'This should be "captured" Working - "this is a test 'this should not capture'" 'this should capture Working - "this isn't a test" 'this should capture 'Comment with a line _ continuation Debug.Print 'End of line comment _ with line continuation. Debug.Print 42 'The next line... _ "...is not a string literal" Debug.Print "Unmatched double quotes." 'Comment" Debug.Print "Interleaved single 'n double quotes." 'Comment" 'No comments or strings in the line below. Debug.Print [Evil:""Comment"'here]