Thank you folks, that worked great!
Paul Giesnehagen
QuillDesign
> The key here of course is the RE -> (Aren't there laws concerning coding
> RE's this late at night? eh? hehe)
>
> <cfscript>
> myList = '22,33.44,21.93,"1,090.33","2,999.00"';
> myList = REReplace(myList, '(")([0-9_]*)([,]*)([0-9_.]*)(")',
'\2\4',
> 'ALL');
> </cfscript>
>
> This should get ya rollin =)
>
>
> Nate Nielsen
> FusionScript DevTeam
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> Develop CF apps that talk to the server without page reloads !
> Create client functionality with CF syntax !
> www.FusionScript.com
>
> ----- Original Message -----
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 16, 2002 12:21 AM
> 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
> >
> >
> >
> >
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
