Sure here you go.
<cfset theList = '"Full Name" "Email Address" "Group List" "Login Name"'>
<cfset theList = replace(theList, '" "', ",", "All")>
<cfset theList = replace(theList, '"', "", "All")>
<cfoutput>#theList#</cfoutput>
Short and sweet.
1. Create the list. Use single quotes to denote the string because the string
contains double quotes.
2. Replace all occurrences of '" "' with ','.
3. Replace the remaining double quotes at the beginning and end of the list with
nothing.
Now you have a standard comma-delimited list.
HTH
-- Bruce
btw - this code will fail if the list contains any double quotes that are not
delimiters.
> -----Original Message-----
> From: Eric Fickes [mailto:[EMAIL PROTECTED]]
> <snip>
> I was hoping to somehow use " " as a delimeter, but that's not working.
> When I do that it takes out the spaces in the column names. I'd like to take
>
> "Full Name" "Email Address" "Group List" "Login Name"
>
> and turn it into
>
> Full Name,Email Address,Group List,Login Name
>
> Any ideas?
>
> E
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
