Converting DateString to integer

TharunJoshi — Sat, 16 Nov 2024 02:20:47 GMT

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]

Re: Converting DateString to integer

manodwhb — Mon, 25 May 2020 01:36:50 GMT

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

topic Re: Converting DateString to integer in Talend Studio

Converting DateString to integer

Re: Converting DateString to integer