ListChangeDelims

Description

Returns list with delimiter characters changed to new_delimiter string.

Category

List functions

Syntax


ListChangeDelims(list, new_delimiter [, delimiters ]) 

See also

ListFirst, ListQualify

Parameters

Parameter
Description
list
List of delimiters to change
new_delimiter
String to use as a new delimiter
delimiters
Set of delimiters used in list

Example

<!--- 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> 



Banner.Novgorod.Ru