Click or drag to resize
sqx

RegularExpressionsRegexReplace Method

Function [nvarchar](max) RegexReplace([nvarchar](max) s, [nvarchar](4000) Pattern, [nvarchar](4000) Replacement)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static SqlChars RegexReplace(
	SqlChars s,
	SqlString Pattern,
	SqlString Replacement
)

Parameters

s
Type: System.Data.SqlTypesSqlChars
[nvarchar](max)
Pattern
Type: System.Data.SqlTypesSqlString
[nvarchar](4000)
Replacement
Type: System.Data.SqlTypesSqlString
[nvarchar](4000)

Return Value

Type: SqlChars
[nvarchar](max)
Remarks
Regex replace function.

NOTE: Default options of Regex are case sensitive and multiline
Examples
SQL
Copy
/* ATENTION: RegexReplace is a powerfull tool. Care should be taken in it's use.
Test your patterns first. */
DECLARE @Pattern nvarchar(4000) = sqx.RegexEscape(N'John Doe')
UPDATE SomeTable
SET SomeField = sqx.RegexReplace(SomeField, @Pattern, N'Dr. Doe, John')
WHERE sqx.RegexIsMatch(SomeField, @Pattern) = 1
See Also