Converting DateString to integer

[TharunJoshi]

Hi,

My excel file has date column which is String datatype
like this:Thu Mar 05 00:00:00 IST 2020

My output should come as 20200305

I want to convert to integer how can I achieve this

What I did is 

TalendDate.formatDate("MM/dd/yyyy",TalendDate.parseDate("yyyy/MM/DD",row1.AS_OF_DATE))

Integer.parseInt(Var.var1)

Error:

Starting job PipeDelimited at 15:00 24/05/2020.

[statistics] connecting to socket on port 3726
[statistics] connected
Exception in component tMap_1 (PipeDelimited)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Thu Mar 05 00:00:00 IST 2020"
at routines.TalendDate.parseDate(TalendDate.java:942)
at routines.TalendDate.parseDate(TalendDate.java:886)
at advantage_bridge.pipedelimited_0_1.PipeDelimited.tFileInputExcel_1Process(PipeDelimited.java:3302)
at advantage_bridge.pipedelimited_0_1.PipeDelimited.runJobInTOS(PipeDelimited.java:3861)
at advantage_bridge.pipedelimited_0_1.PipeDelimited.main(PipeDelimited.java:3710)
Caused by: java.text.ParseException: Unparseable date: "Thu Mar 05 00:00:00 IST 2020"
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:928)
... 4 more
[statistics] disconnected

Job PipeDelimited ended at 15:00 24/05/2020. [exit code=1]

[manodwhb · Accepted solution]

AS_OF_DATE datatype as String

Integer.valueOf(TalendDate.formatDate("yyyyMMdd", TalendDate.parseDate("EEE MMM dd HH:mm:ss zzz yyyy", row1.AS_OF_DATE)))