ADMIN_SplitText

 Show all Hide all

Deprecated.

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.

Type: Table-valued function
Area of use: General use

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.
Repeat mode: 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).