topic Re: UnParseable Date format in Talend Studio

UnParseable Date format

oguedda — Fri, 15 Nov 2024 23:27:51 GMT

Hello,

I am trying to read the respons of an API request using talend open studio. All the string and date fields in the respons are in this format :

Nov 25, 2021, 07:10:13 PM

déc. 1, 2021

I tried this

pattern

but steal have the same error (

UnParseable Date format)

TalendDate.parseDate(TalendDate.parseDate("mm dd', ' yyyy', ' HH:mm:ss XX",[row7.Start_Time])
TalendDate.parseDate(TalendDate.parseDate("mm'.' dd',' yyyy",[row7.Backup_Window])

How to parse this kind of string ? what is the

right date format pattern for the below date style

Thanks in advance.

gjeremy1617088143 — Wed, 01 Dec 2021 13:18:43 GMT

Hi,

maybe you can try this pattern :

"MMM dd, yyyy, HH:mm:ss a" for the first one

and

"MMM. d, yyyy" for the second one

Send me love and kudos

oguedda — Wed, 01 Dec 2021 14:06:19 GMT

HI Jeremy,

Thank you, it works fine. here is the full expression : TalendDate.parseDateLocale("MMM d, yyyy, HH:mm:ss a", "Nov 25, 2021, 07:10:13 PM","en")