K,
Fair enough. The expression removes all characters that aren't a digit or
decimal point(0-9 or .).
rereplace(vartocleanup, "[^0-9\.]+", "", "ALL")
Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL")
depends on the source of the numbers. If you have some legacy data or other
controlled source where you know the only issue will be commas, Don's
replace will do ya just fine. If there's a chance you might face other
non-numeric characters (currency symbols, etc.), the rereplace would be more
appropriate. Right tool for the job and all that.
HTH,
Sean G.
-----Original Message-----
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 4:09 PM
To: [EMAIL PROTECTED]
Subject: RE: Comma/Number Problem
No offense to you Shawn but with new people, which he obvioulsy is as he
doesn't know about replace, you should probably explain what this does
instead of just supplying it.
--K
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
