A copy of the list, with each delimiter character replaced by new_delimiter.
ListChangeDelims(list, new_delimiter [, delimiters ])
<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>