Hi I have a requirement where
A1 will become A001
A13 will become A013
Please suggest how to get this.
Regards,
changing format
Moderators: chulett, rschirm, roy
If you always have only one alphabet and followed by any number of digits then try this
Code: Select all
svAlpha=input_field[1,1]
svNum=input_field[2]
target_field=svAlpha : right('000':svNum,3)
You are the creator of your destiny - Swami Vivekananda
NewColumn = in.Field[1,1]:FMT(In.Field[2,99],"3'0'R")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am