Data conversion

arshi · Post by **arshi** » Mon Apr 21, 2008 12:14 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 12:17 am

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")

sinhasaurabh014 · Post by **sinhasaurabh014** » Mon Apr 21, 2008 6:39 am

Oconv(Iconv(DSLink3.Inp_Dat,"D MY[2,4]"),"D-MBY[,2]")
where DSLink3.Inp_Dat ---source link name and Inp_Dat is the column name.

Nothing different..from the earlier response...you see