Hi
I have got a varchar field. The records coming are like 0000006.50 and I want to get only 6.50. How is this possible?
Regards
Arnie
How to remove the leading Zeros
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
TRIM In.String '0' 'F' in a modify stage would do the trick
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
Yes, the syntax is different; like the Server stage syntax. It is available in the PDFs or online help.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Since, it is a Varchar field, the same TRIM function will do the trick in Transformer stage aswell.
Code: Select all
Trim(Input_Col,'0','L')
Thanks and Regards!!
dspxlearn
dspxlearn
Prabhakar - but he stated in his original post that he had a VarChar() column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>