Problem converting Quarter and Fiscal year to date format

[Darmesh]

1QFY16, 2QFY16, 3QFY16, 4QFY16 this is the data will be there in excel file

The problem is, Using tReplace i have replaced 1QFY as "Jun-" similarlly for remaining 2QFY as "Sep-"
3QFY as "Dec-"
4QFY as "Mar-"
so the output will be like Jun-16, Mar-16, Dec-16, Mar-16 as per above 1QFY16 ......

But the actual ouptput should be Jun-15, Mar-15, Dec-15, Mar-16 instead of Jun-16, Mar-16, Dec-16, Mar-16.

Required Output in string format.

1QFY16 - Jun-15
2QFY16 - Sep-15
3QFY16 - Dec-15
4QFY16 - Mar-16
1QFY17 - Jun-16
2QFY17 - Sep-16
3QFY17 - Dec-16
4QFY17 - Mar-17

[Anonymous]

hi ,

in tmap use below code

row3.newColumn.replace("1QFY","Jun-").replace("2QFY","Sep-").replace("3QFY","Dec-").replace("4QFY","Mar-")  it will work