Eric,
You can also use Regular Expression to do this, although my example could
likely use some work:
<CFSET MyList = REReplace(MyList, """([[:alnum:] ]*)"" ?", "\1,", "ALL")>
Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/
----- Original Message -----
From: "Eric Fickes" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 06, 2000 11:30 PM
Subject: List w/" " delims
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
