RegexSplitCount

Returns the highest available Index that can be used using the Split function (Regex Version)

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.RegexSplitCount ( @Text, @RegexPattern )

Arguments:

Name	Type	Description
@Text	nvarchar(MAX)	String expression containing substrings and delimiters.
@RegexPattern	nvarchar(4000)	String expression containing a regex expression. See Regular Expression Language – Quick Reference for more information. Even though this parameter is required, a NULL value indicates that no regex expression is to be used.



Return Type:

int



Sample Usage:

Split by whitespace sequences of any size:


DECLARE @Text nvarchar(MAX)
DECLARE @RegexPattern nvarchar(4000)

SET @Text = 'The quick brown fox jumps over the lazy dog'
SET @RegexPattern = '\s+'

SELECT SQLHTTP.net.RegexSplitCount(@Text, @RegexPattern)

DECLARE @Text nvarchar(MAX)

DECLARE @RegexPattern nvarchar(4000)

SET @Text = 'The quick brown fox jumps over the lazy dog'

SET @RegexPattern = '\s+'

SELECT SQLHTTP.net.RegexSplitCount(@Text, @RegexPattern)

-----

Split by alphabetic strings to extract numeric values:


DECLARE @Text nvarchar(MAX)
DECLARE @RegexPattern nvarchar(4000)

SET @Text = 'Abc1234Def5678Ghi9012Jklm'
SET @RegexPattern = '[a-zA-Z]+'

SELECT SQLHTTP.net.RegexSplitCount(@Text, @RegexPattern)

DECLARE @Text nvarchar(MAX)

DECLARE @RegexPattern nvarchar(4000)

SET @Text = 'Abc1234Def5678Ghi9012Jklm'

SET @RegexPattern = '[a-zA-Z]+'

SELECT SQLHTTP.net.RegexSplitCount(@Text, @RegexPattern)

-----



RegexSplitCount

Featured API Wrapper Code / SQL Server