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
-----Original Message-----
From: Sean German [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:51 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Comma/Number Problem
This is something I've picked up from this list.
cleanNumber = rereplace(vartocleanup, "[^0-9\.]+", "", "ALL")
HTH,,
Sean G.
-----Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 3:24 PM
To: [EMAIL PROTECTED]
Subject: Comma/Number Problem
Hi,
I am trying to add a bunch of numbers to get a total value. It works fine
unless someone uses a comma to separate 'thousands':
Ex. 10,500
How do I get rid of the comma before I add it up??
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.