Why Not use the replace command
<CFSET X=Replace(x,chr(34) & chr(32) & chr(34),",","ALL")>
This should replace all " " with , all you have to deal with are the " at
the start and end which can be donw with
<CFSET X=Replace(x,chr(34),"","ALL")>
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-----Original Message-----
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: 08 December 2000 13:29
To: CF-Talk
Subject: RE: List w/" " delims
You CAN use multiple characters as list delimiters...eg. "|*|".
I do it frequently to cut down on the chances that one of my list items
contains a delimiter.
Jeff Britts
ColdFusion Engineer
e-Dialog
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 2:21 PM
To: CF-Talk
Subject: Re: List w/" " delims
Keep in mind that list delimiters can only be 1 character.
--
Billy Cravens
[EMAIL PROTECTED]
Eric Fickes wrote:
>
> Got a List question for you.
>
> I've got a text file that I need to parse and it's " delimited list, in a
> way. The list format is this.
>
> "Full Name" "Email Address" "Group List" "Login Name"
> "Demo user for startup" "" " 1;" "Demo"
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists