Cool Tips‎ > ‎

String Manipulation

 

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    

 

 


 

 


 

 


Comments