ADMIN_SplitText

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Table-valued function

Splits the supplied string into several substrings at a specific character or sequence of characters. Each substring is returned on a separate row in the resultset.

If the supplied value is an empty string, null, or contains only blanks, then a single row with the value null is returned.

This function is deprecated since version 5.3.005. Use ADMIN_SplitString instead.

Parameters

@txt mandatory text
The text that should be splitted.
@delimiter mandatory varchar(8000)
The character or character sequence to split at.

Resultsets

Resultset: Substrings

Each string fragment is returned on a separate row.
Table count: repeated exactly once
Row count: zero or more rows

Columns

id mandatory int
The ordinal of the string fragment.
txt mandatory string
The string fragment or null if the value is empty (after trimming whitespace).