ListChangeDelims

Returns list with all delimiter characters changed to new_delimiter string.

Syntax

ListChangeDelims(list, new_delimiter [, delimiters ])

list

List of delimiters being changed.

new_delimiter

String being used as a new delimiter.

delimiters

Set of delimiters used in list.

Examples

<!--- This example shows ListChangeDelims --->
<HTML>
<HEAD>
<TITLE>ListChangeDelims Example</TITLE>
</HEAD>

<BODY>
<H3>ListChangeDelims Example</H3>

<P>ListChangeDelims allows you to change the delimiters
used in a list.
<!--- First, query to get some values for our list --->
<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: #temp#
</CFOUTPUT>
<!--- now, change the delimiters in the list from "," to
"|:P|"--->
<CFSET temp2 = ListChangeDelims(Temp, "|:P|", ",")>
<CFOUTPUT>
<P>The appended list: #temp2#
</CFOUTPUT>

</BODY>
</HTML>

CFML Language Reference
Chapter 2 : ColdFusion Functions