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

[Anonymous]

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.

[Rajesh_Reddy1]

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

[vapukov]

generally - it not hard:

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