topic Re: Convert String to Date in Talend Studio

Convert String to Date

Karuetl — Sat, 16 Nov 2024 04:50:11 GMT

I get the data in excel as below format and needs to convert into YYYY-MM-DD

Monday, May 20, 2013

Re: Convert String to Date

tnewbie — Wed, 28 Aug 2019 22:59:05 GMT

At the outset this sounds simple...not sure if i am missing something here. If you can handle the format of the incoming date, you should be able to convert the value to any of the format that you want...For you to be able to identify the incoming date format (from the little i understood from your problem description) I have enclosed a screen shot ...please see if that helps. (As I tried this in one of my jobs for privacy concerns i have grayed out the rest..hope you focus on the ungrayed part)

I would request, to be considerate in your postings going forward and try to explain bit more than what you did currently...Thanks for your understanding.

dt_issue.png

Re: Convert String to Date

Karuetl — Thu, 29 Aug 2019 14:21:11 GMT

Some date value has in below format

"Sunday, 2 June 2019".

While most are in the format - "Thursday, November 01, 2012"

Re: Convert String to Date

rmartin2 — Thu, 29 Aug 2019 17:05:36 GMT

This means you have different formats, so you need DataQuality components.

Then just use the one to correct dates (I think there's one). It should be automatic.

Re: Convert String to Date

Anonymous — Thu, 29 Aug 2019 17:49:09 GMT

Hi,

The best method is to educate the source team to send the data in a unified format. But they are not ready, you will have to add multiple parse conditions to parse different date formats. Not an ideal way of doing for an enterprise level environment but that is the best you can do.

You will have to use a combination of TalendDate.isDate() and TalendDate.parseDate() functions to parse all different formats.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved