Regular Expressions 101

Community Patterns

T-SQL find text blocks in script

1

Regular Expression
PCRE2 (PHP >=7.3)

/
(?<text>N?'((?:''|[^'])*)'|N?"((?:""|[^"])*)")
/
gms

Description

Finds the text blocks in a t-sql (tsql) script

Submitted by Paw Jershauge - a month ago