RE: TRIM or REPLACE?

2001-08-06 Thread Timothy Dineen
I just wanted to say thank you for the sharp advise you provided to me more than a week ago when I was in need. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 5:16 AM To: CF-Community Subject: RE: TRIM or REPLACE? Use the RemoveChars

RE: TRIM or REPLACE?

2001-08-06 Thread Timothy Dineen
I just wanted to say thank you for the sharp advise you provided to me more than a week ago when I was in need. -Original Message- From: Dain Anderson [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:04 PM To: CF-Community Subject: Re: TRIM or REPLACE? Timothy, If you know

RE: TRIM or REPLACE?

2001-08-06 Thread Timothy Dineen
I just wanted to say thank you for the sharp advise you provided to me more than a week ago when I was in need. -Original Message- From: Ledwith, Brian [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 9:28 PM To: CF-Community Subject: RE: TRIM or REPLACE? Tim, Using trim is

RE: TRIM or REPLACE?

2001-07-27 Thread John McCosker
Use the RemoveChars Function: JMC -Original Message- From: Timothy Dineen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:13 AM To: CF-Community Subject: TRIM or REPLACE? Hey everyone: OK, On a good day I could do this, but this hasn't been a good day: I need to take a vari

Re: TRIM or REPLACE?

2001-07-26 Thread Dain Anderson
Timothy, If you know for certain your field always has a "dash" (-) in the string, you could do this with a one-liner: Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: "Timothy Dineen" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sen

RE: TRIM or REPLACE?

2001-07-26 Thread Ledwith, Brian
Tim, Using trim is always a good idea for removing leading and trailing spaces, especially from user provided data, but what you need here is to do one of the following (there are few other ways...) Either replace the "F-" with a "", or do a "mid" starting after the "F-" to the end, or grab the

RE: TRIM or REPLACE?

2001-07-26 Thread Mark Warrick
I'm sure there's other ways of doing this, but this code will work: Original String: #thestring# New String: #thestring# ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-