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 e
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
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 peo
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 PROT
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 works
ne . . . 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,",
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
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 a
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 get a total value. It works fine
> un
9 matches
Mail list logo