Comma/Number Problem

2000-08-10 Thread S R
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

Re: Comma/Number Problem

2000-08-10 Thread Don Vawter
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

RE: Comma/Number Problem

2000-08-10 Thread Sean German
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:

RE: Comma/Number Problem

2000-08-10 Thread Dan Haley
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

RE: Comma/Number Problem

2000-08-10 Thread Dan Haley
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,",

Re: Comma/Number Problem

2000-08-10 Thread Sean Renet
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

RE: Comma/Number Problem

2000-08-10 Thread Chapman, Katrina
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

RE: Comma/Number Problem

2000-08-10 Thread Sean German
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

RE: Comma/Number Problem

2000-08-10 Thread Chapman, Katrina
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

RE: Comma/Number Problem

2000-08-10 Thread S R
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