topic Re: Parsing dynamic date type and format change in Talend Studio

Parsing dynamic date type and format change

kmrprvn — Sun, 22 Mar 2020 17:51:16 GMT

Hi Folks,

I got requirement to parse date type fields and convert to dd-mm-yyyy format. but here problem is, date data will change for every row like below, Can you please help how i can parse the date dynamically and format as above.
Source:
20-05-1994
1999-17-05
05-25-2001

Thanks in advance.

Re: Parsing dynamic date type and format change

Anonymous — Wed, 25 Mar 2020 09:35:13 GMT

Hi
Call the built-in function TalendDate.isDate(String stringDate, String pattern) to check the date pattern, if true, use the corresponding date pattern to parse the date, TalendDate.parseDate(String pattern, String stringDate).
Please try and let me know if you have any issue.

Regards
Shong