THANK YOU THOMAS!
Quoting Thomas Bean <[EMAIL PROTECTED]>:
This should also work:
LEFT($Name$, LENGTH($Name$) - 1)
----- Original Message -----
From: "Thomas Bean" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Wednesday, October 24, 2007 12:02 PM
Subject: Re: Question: Removing Last Character
I believe this should work in a set fields action:
SUBSTR($Name$, 0, LENGTH($Name$) - 2)
HTH,
Thomas
----- Original Message ----- From: "T. Dee" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Wednesday, October 24, 2007 11:53 AM
Subject: Question: Removing Last Character
I'm looking for the command to remove the last character in a field. For
example taking "JohnS" and returning "JohnS". I just need to take away the
last character.
Any help would be appreciated!
Thanks!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
