Problem converting Quarter and Fiscal year to date format

Darmesh — Fri, 26 Oct 2018 10:02:14 GMT

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

Re: Problem converting Quarter and Fiscal year to date format

Anonymous — Tue, 13 Nov 2018 14:34:00 GMT

hi ,

in tmap use below code

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

topic Re: Problem converting Quarter and Fiscal year to date format in Talend Studio

Problem converting Quarter and Fiscal year to date format

Re: Problem converting Quarter and Fiscal year to date format