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]
