ListChangeDelims  
Description
Changes a list delimiter.
 
Returns
A copy of the list, with each delimiter character replaced by new_delimiter.
 
Category
List functions
 
Function syntax
ListChangeDelims(list, new_delimiter [, delimiters ])
 
See also
ListFirst, ListQualify
 
Parameters
 
Parameter      Description
list A list or a variable that contains one.
new_delimiter Delimiter string or a variable that contains one. Can be an empty string. ColdFusion
  processes the string as one delimiter.
delimiters A string or a variable that contains one. Character(s) that separate list elements.
  Default: comma.
  If this parameter contains more than one character, ColdFusion processes each
  occurrence of each character as a delimiter.
 
Example
<h3>ListChangeDelims Example</h3>
<p>ListChangeDelims lets you change the delimiters of a list.
<!--- First, query to get some values for our list elements--->
<CFQUERY NAME="GetParkInfo" DATASOURCE="cfsnippets">
SELECT    PARKNAME,CITY,STATE
FROM    Parks
WHERE    PARKNAME LIKE 'BA%'
</CFQUERY>
<CFSET temp = ValueList(GetParkInfo.ParkName)>
<cfoutput>
<p>The original list: <p>#temp#
</cfoutput>
<!--- Change the delimiters in the list --->
<CFSET temp2 = ListChangeDelims(Temp, "|:P|", ",")>
<cfoutput>
<p>After executing the statement 
<strong>ListChangeDelims(Temp, "|:P|", ",")</strong>, 
the updated list: <p>#temp2#
</cfoutput>
list  
A list or a variable that contains one.
new_delimiter  
Delimiter string or a variable that contains one. Can be an empty string. ColdFusion processes the string as one delimiter.
delimiters  
A string or a variable that contains one. Character(s) that separate list elements. Default: comma.
If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.