ListChangeDelims

Changes a list delimiter.

A copy of the list, with each delimiter character replaced by new_delimiter.

List functions

ListChangeDelims(list, new_delimiter [, delimiters ])

ListFirst, ListQualify

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.

<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>

View comments on LiveDocs