topic Re: Convert String from Excel to Date in Talend Studio

Convert String from Excel to Date

Ferdinand_CUNY — Sat, 16 Nov 2024 00:52:57 GMT

Hello,

I would like to load data from Excel File to DB.

Format in Excel is String and Date in targe table.

But, the string value is in this format: "Wed Dec 30 00:00:00 CET 2020"

How I can conert to date format

Caused by: java.text.ParseException: Unparseable date: "Wed Dec 30 00:00:00 CET 2020"

at java.text.DateFormat.parse(Unknown Source)

at routines.TalendDate.parseDate(TalendDate.java:929)

Anonymous — Tue, 05 Jan 2021 04:41:18 GMT

Hello,

You can use built-in function TalendDate.parse to parse String to Date.

Here exist a component tConvertType which is also used to convert one Talend java type to another automatically, and thus avoid compiling errors.

Let us know if it helps.

Best regards

Sabrina

Ganshyam — Tue, 05 Jan 2021 06:49:17 GMT

Hello,

Try below.

TalendDate.parseDate("dd/MM/yyyy",TalendDate.formatDate("dd/MM/yyyy",TalendDate.parseDate("EEE MMM dd HH:mm:ss Z yyyy",row1.Ship_Date)))

Regards