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
>
>
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
