Remove Leading Zero

How to remove leading zeros in data and transform data to target?

Questions by goodfriendsri

Showing Answers 1 - 7 of 7 Answers


  • Oct 8th, 2011

in transformer stage using trim function we can delete the leading zeros

  Was this answer useful?  Yes


  • Nov 29th, 2011

Trim function could't removes the leading zero's , its just removes the leading spaces

  Was this answer useful?  Yes

karn khera

  • Feb 28th, 2013

TRIM(0,.,A) It will remove 0s all occurance after .

  Was this answer useful?  Yes

Rupesh Agrawal

  • Nov 8th, 2013

convert data to integer and convert back to string.

  Was this answer useful?  Yes


  • Dec 2nd, 2013

The main differences between 8.1 and 8.5 are

8.5 has Input looping ,Output looping.
8.5 has saving ,editing and compling is 40% faster.
8.5 has functions like LastRow,LastInGroup and Iteration system Variables added.
8.5 has new date functions are added DataFromComponents and DateOffsetByComponents.
8.5 Null values are handled using APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING
8.5 has vertical pivoting.
8.5 has integration CVS.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions