Hi,
How to convert the source data for one column 'June 2006' to 'Jun-06'.
The datatype for this column is Varchar,
Is it required to write a routine for this.
Regards,
Arshi
Data conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, you can do it with an expression. For example (and this is not the only way):
Code: Select all
Oconv(Iconv("01 " : InLink.TheString, "DDMY"), "D-MBYL")
Last edited by ray.wurlod on Mon Apr 21, 2008 4:42 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 86
- Joined: Wed Apr 02, 2008 2:32 am
- Location: Bangalore