Click or drag to resize
sqx

RegularExpressionsRegexSplitTable Method

Function [table] RegexSplitTable([nvarchar](max) s, [nvarchar](4000) Pattern)

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

Parameters

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

Return Value

Type: IEnumerator
[table]
Remarks
Regex split table function.

NOTE: Default options of Regex are case sensitive and multiline

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "Value nvarchar(max)"
Examples
SQL
Copy
DECLARE @s nvarchar(max) = N'This is a word split test.'
SELECT * FROM sqx.RegexSplitTable(@s, N'\ ')
/*
Value
-----
This
is
a
word
split
test.*/
See Also