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??
EX. 10500
Thanks
Sal
Get
How about newstring=replace(oldstring,",","","ALL")
- Original Message -
From: "S R" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 10, 2000 1:24 PM
Subject: Comma/Number Problem
Hi,
I am trying to add a bunch of numbers to
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:
Or, evn easier - val("somenumber") . . . val("10,500") = 10500
Dan
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Comma/Number Problem
How about newstring=replace(o
on this one . . . go with the "cleanNumber" setup mentioned by
Sean G.
Dan
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Comma/Number Problem
How about newstring=replace(oldstring,",
use a | as your delimiter. That is the think that is SHIFT-\
- Original Message -
From: "S R" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 10, 2000 12:24 PM
Subject: Comma/Number Problem
Hi,
I am trying to add a bunch of numbers to get a total value. It
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: Thu
priate. 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 obviou
Good Job! You get a gold star for the day!
--K
-Original Message-
From: Sean German [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 2:09 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Comma/Number Problem
K,
Fair enough. The expression removes all characters that aren't a digit
Thanks a lot. It worked!!!
Sal
From: Sean German [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
Subject: RE: Comma/Number Problem
Date: Thu, 10 Aug 2000 17:08:34 -0400
K,
Fair enough. The expression removes all characters that aren
10 matches
Mail list logo