>Try this:
>
><cfset string = '11/12/2003, "bob", "this is a ,comma,list","end"'>
><cfscript>
> string = string & ",";
> first = find('"', string);
> second = find('"', string, first + 1);
> while(first and second)
> {
> string = left(string, first) & replace(mid(string, first + 1,
>second-first), ',', '~', "all") & right(string, len(string) - second);
> first = find('"', string, second + 1);
> second = find('"', string, first + 1);
> }
></cfscript>
>
>
>You'll notice that I append a comma to the end of the list. This is so
>that a double-quote can't be the last character. Sine CF ignores empty
>list entries, this shouldn't affect the rest of your code. If it does,
>just strip the last character at the end of the script.
>
>HTH.
>
>--Ben Doom
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
