Returns list with delimiter characters changed to new_delimiter string.
ListChangeDelims(list, new_delimiter [, delimiters ])
Parameter |
Description |
---|---|
list |
List of delimiters to change |
new_delimiter |
String to use as a new delimiter |
delimiters |
Set of delimiters used in list |
<!--- This example shows ListChangeDelims ---> <html> <head> <title>ListChangeDelims Example</title> </head> <body> <H3>ListChangeDelims Example</H3> <P>ListChangeDelims lets you 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>