Regular Expressions 101

Community Patterns

Community Library Entry

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 - 8 months ago