topic Convert a string to another string in tmap - from "Fri Jun 07 00:00:00 CEST 2019" to 2019-06-07 in Talend Studio

Convert a string to another string in tmap - from "Fri Jun 07 00:00:00 CEST 2019" to 2019-06-07

Anonymous — Sat, 16 Nov 2024 04:45:49 GMT

Hi everyone,

I need to convert the following string Fri Jun 07 00:00:00 CEST 2019 to another string but with the format 2019-06-07 (yyyy-MM-dd).

Can anyone help, please? I have been trying everything but I can't find a solution!

Thank you in advance

Re: Convert a string to another string in tmap - from "Fri Jun 07 00:00:00 CEST 2019" to 2019-06-07

Anonymous — Thu, 05 Sep 2019 17:50:05 GMT

        SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzzz yyyy");
        Date d = sdf.parse("Fri Jun 07 00:00:00 CEST 2019");
        sdf.applyPattern("yyyy-MM-dd");
        String newDateString = sdf.format(d); //2019-06-07

may be worth putting into a tJavaRow beforehand rather than running all this through a tMap

Re: Convert a string to another string in tmap - from "Fri Jun 07 00:00:00 CEST 2019" to 2019-06-07

Anonymous — Thu, 12 Sep 2019 09:03:49 GMT

Thank you very much! It worked for me : )

Re: Convert a string to another string in tmap - from "Fri Jun 07 00:00:00 CEST 2019" to 2019-06-07

Anonymous — Wed, 25 Sep 2019 03:28:42 GMT

@Gerard_BA

Another option is to convert using Talend date parsing functions available in tMap as shown in below link.

https://community.talend.com/t5/Design-and-Development/Convert-format-EEE-MMM-dd-HH-mm-ss-Z-yyyy-to-YYYY-MM-DD/m-p/202890#M110877

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