Hi Travis,

After removing the 'RQST', try

REPLACE(LTRIM(REPLACE($Field$, "0", " ")), " ", "0")

This replaces all '0's with spaces, left trims, then restores the wanted
zeros within the number.

HTH

Cheers

Peter

-----Original Message-----
From: Travis Wirt [mailto:travis@TELAMON.COM]
Sent: 21 December 2001 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: stripping leading zeros


**

I need to be able to take an ID number like "RQST00000013778" and turn it
into "13778".
I can strip the "RQST" easy enough with a REPLACE function.
I can use $Field$ LIKE "0" + "%" to determine if there are leading zeros
but how would I trim them. LTRIM deals with white space and REPLACE would
remove all zeros not just the leading ones. I could temporarily put it in a
number field but they seem to hang on to the leading zeros as well. I am
currently leaning toward a run process with a PERL script. Does anyone have
any other suggestions?

Travis Wirt

__________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org


Please visit us at http://www.sonybiz.net

*************************************************************************
The information contained in this message or any of its
attachments may be privileged and confidential and intended
for the exclusive use of the addressee. If you are not the
addressee any disclosure, reproduction, distribution or other
dissemination or use of this communication is strictly prohibited
*************************************************************************

__

You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org

Very elegant. Very nice!

--gf

On Wed, 2 Jan 2002 10:00:38 Romain, Peter wrote:
>**
>
>Hi Travis,
>
>After removing the 'RQST', try
>
>REPLACE(LTRIM(REPLACE($Field$, "0", " ")), " ", "0")
>
>This replaces all '0's with spaces, left trims, then restores the wanted
>zeros within the number.
>
>HTH
>
>Cheers
>
>Peter
>
>-----Original Message-----
>From: Travis Wirt [mailto:travis@TELAMON.COM]
>Sent: 21 December 2001 17:57
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: stripping leading zeros
>
>
>**
>
>I need to be able to take an ID number like "RQST00000013778" and turn it
>into "13778".
>I can strip the "RQST" easy enough with a REPLACE function.
>I can use $Field$ LIKE "0" + "%" to determine if there are leading zeros
>but how would I trim them. LTRIM deals with white space and REPLACE would
>remove all zeros not just the leading ones. I could temporarily put it in a
>number field but they seem to hang on to the leading zeros as well. I am
>currently leaning toward a run process with a PERL script. Does anyone have
>any other suggestions?
>
>Travis Wirt
>
>__________________
>_____________
>
>
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>
>Please visit us at http://www.sonybiz.net
>
>*************************************************************************
>The information contained in this message or any of its
>attachments may be privileged and confidential and intended
>for the exclusive use of the addressee. If you are not the
>addressee any disclosure, reproduction, distribution or other
>dissemination or use of this communication is strictly prohibited
>*************************************************************************
>
>__
>
>You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org
>


Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com

__

You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org