ColdFusion 9 CFML Reference

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, includeEmptyValues ])

See also

ListFirst, ListQualify; Lists in the Developing ColdFusion Applications

Parameters

Parameter

Description

includeEmptyValues

Optional. Set to yes to include empty values.

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. Characters that separate list elements. The default value is 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="cfdocexamples"> 
    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>