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; "Lists" in Chapter 3, "Using ColdFusion Variables," in ColdFusion MX Developer's Guide
Parameters
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>

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. The default value is comma.

If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.