Convert String to Date

[Karuetl]

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

Monday, May 20, 2013

[tnewbie]

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

[Karuetl]

Some date value has in below format 

"Sunday, 2 June 2019".

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

[rmartin2]

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.

[Anonymous]

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