on 08-28-2007 1:54 PM
HI,
I am receiving a value 000000000001111 i want to truncate the leading zero's.
the value to be send to target field should be 1111, do we have any standard function to perform this.
Regards,
Jeff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FormatNum Arithematic function is the standard function u can use
Prateek
Thanks,
Format worked
Hi Jeff,
Use the TRIM function from TEXT....
Kumar.
P.S: Reward points if helpful!!!!
Hi Kumar,
Trim is not truncating leading zero's
i tried it
Oh sorry,,,
TRIM is for blank spaces... as prateek metioned use format number.
kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.