Title
|
Description
|
Applicability
|
Very Fast String Splitter
|
Pivots a delimited list into a single column results table.
|
2000, 2005, 2008, 2008R2, 2012
|
Alternate String Splitter (Tally Table)
|
Utilizes a tally (numbers) table to parse and split a string in one pass, with no looping.
|
2000, 2005, 2008, 2008R2, 2012
|
Alternate String Splitter (XML)
|
Utilizes XML to parse and split a string in one pass, with no looping (replaces delimiter with artificial XML tag).
|
2000, 2005, 2008, 2008R2, 2012
|
Enhanced String Cleaner/Trimmer
|
Removes non-breaking spaces and all other control characters from the leading and trailing edges of a string.
|
2000, 2005, 2008, 2008R2, 2012
|
Get Occurrences of Character in String
|
Returns the ordinal position of all occurrences of the supplied character in the supplied string. Optional enforcing of case sensitivity.
|
2000, 2005, 2008, 2008R2, 2012
|
Get Count of
Occurrences of Character in String
|
Returns the count of all occurrences of the supplied character in the supplied string. Optional enforcing of case sensitivity.
|
2000, 2005, 2008, 2008R2, 2012
|
Extract Parts of an IP String
|
Returns all for parts of a full IP string (IPv4 only). Utilizes the system function PARSENAME().
|
2000, 2005, 2008, 2008R2, 2012
|
Get Nth item from delimited string
|
Returns the Nth item from a delimited list supplied in a single string. Delimiter can be any single character.
|
2000, 2005, 2008, 2008R2, 2012
|
Extract Parts of a URL String
|
Parses a URL string and returns Base URL, Page Name and Parameter String portions, along with the original URL String.
|
2000, 2005, 2008, 2008R2, 2012
|
Add Leading Zeros to Integer String
|
Function to return an integer string left padded to a specified width with '0'. Integer must be supplied as a string.
|
2000, 2005, 2008, 2008R2, 2012
|
|
|
|
|
|
|
|
|
|