This seems to work on the data you supplied...
#REReplace(MyList,
"""(([[:digit:]]+),)?([[:digit:]]+)(.[[:digit:]]+)?""", "\2\3\4",
"All")#
Regards,
Matthew Walker
/*
Easier, smarter forms:
http://www.matthewwalker.net.nz/inform2
*/
> -----Original Message-----
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 16 May 2002 5:21 p.m.
> To: CF-Talk
> Subject: List, Quotes, Commas UGH
>
>
> I have a list with comma's and quotes, here is a sample:
>
> 22,33.44,21.93,"1,090.33","2,999.00"
>
> I need to strip out the " as well as take the comma out of
> the thousand number so 1,999 would be 1999 but still keep my
> list in tact
>
> NOTE: ,"1,090.33","2,999.00" Those values are seperated by a comma
>
> If I replace " with nothing, then my list gets out of wack
> because of the 1,999 comma ..
>
> I am sure there is a simple method to roll through these, but
> I am sure someone has a quick answer...
>
> Thanks in advance!
>
> Paul Giesenhagen
> QuillDesign
>
>
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
