UnParseable Date format

[oguedda]

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

or

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 · Accepted solution]

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]

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")