? TRANSFORM(VAL(SUBSTR("SE7130000000001201212345",6,19)))
>Hi,
>
>I have a character string as below:
>
>SE7130000000001201212345
>
>I then do the following
>
>? SUBSTR("SE7130000000001201212345",6,19)
>
>which gives me
>
>0000000001201212345
>
>How can I remove the preceeding zeros with out deleting the zeros after the first number? Bear in mind the first number is not always in the same position.
>
>What I want is:
>
>1201212345
>
>Thanks,
>
>Ger
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst