topic Re: How to convert string (excel, csv) to string format "FW35 - 2018" in Talend Studio

How to convert string (excel, csv) to string format "FW35 - 2018"

Anonymous — Fri, 05 Oct 2018 12:02:32 GMT

I need to convert a string in excel, csv format to a string output formatted as "FW35 - 2018" with fiscal year beginning 1/1/2018.

Input string format: 8/1/2018 7:59 (in excel, .csv format)

Output String format: FW35 - 2018 (FW=Fiscal Week, Fiscal Year begins 01/01/2018)

Any help or suggestions would be helpful. Thank you.

Re: How to convert string (excel, csv) to string format "FW35 - 2018"

Rajesh_Reddy1 — Fri, 05 Oct 2018 12:17:56 GMT

TRY THIS

"FW"+

String.valueOf(TalendDate.getPartOfDate("WEEK_OF_YEAR",TalendDate.parseDate("MM/dd/yyyy", "8/1/2018 7:59")))
+" - " +
String.valueOf(TalendDate.getPartOfDate("YEAR",TalendDate.parseDate("MM/dd/yyyy", "8/1/2018 7:59")))

Re: How to convert string (excel, csv) to string format "FW35 - 2018"

vapukov — Fri, 05 Oct 2018 12:26:27 GMT

generally - it not hard:

"FW"+String.valueOf(TalendDate.getPartOfDate("WEEK_OF_YEAR",raw1.dateCol))+" - "+String.valueOf(TalendDate.getPartOfDate("YEAR",raw1.dateCol))