hi,
I have a source records which are not fixed length.I am giving some examples as mentioned below :
1. 0012345
2. 072945
3. 001239567
4. 1234576
5. 0007992345
But i need only those records except 0 [ removing all 0 from the preciding position ] means output will be like as follows .
1. 12345
2. 72945
3. 1239567
4. 1234576
5. 7992345
Kindly help me ..
Removing all preceding zeros [0]
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
The TRIM function, while usually called with only one parameter, has several options that are quite handy. In this case, you could do a This means trim all leading 0's from the column "In.NumberColumn".
Code: Select all
Trim(In.NumberColumn,'0','L')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>