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 e

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

RE: Comma/Number Problem

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

RE: Comma/Number Problem

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

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 works

RE: Comma/Number Problem

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

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 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: Comma/Number Problem Hi, I a

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 get a total value. It works fine > un