Hi Kay, I like a regular expression for this sort of thing.. but it's just personal preference as I am often turning $10,000 into 10000. I will also turn $10,000.00 into 10000.00
reReplace(string,"[^0-9.]","","all") This will remove anything that isn't a number or a "." (leaving decimal points in place) Cheers, Adam -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Friday, 7 April 2006 11:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] what's the 'proper way' to remove comma formatting from numbers Hey guys, I can think of all sorts of ways to actually do it, but what's the most correct/bulletproof way to turn 10,000 into 10000? -- Kay Smoljak http://kay.zombiecoder.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---