topic Re: TalendDate.parseDate: Unparseable date only for "May" in Talend Studio

TalendDate.parseDate: Unparseable date only for "May"

Romanesku — Sat, 16 Nov 2024 08:13:28 GMT

Hi,

I have problem with parsing date from csv file. My function tMap look like

TalendDate.parseDate("[dd/MMM/yyyy:HH:mm:ss.SSS]",row7.fulltime )

when this job runs in mounts ago: April, March with values like [01/Apr/2018:00:00:09.236]

everything works well, but from May I have problem, value [01/May/2018:00:00:09.236] return an exception

Exception in component tMap_1 (TestMayError)

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "[01/May/2018:00:00:09.236]"

Do you have idea what should be wrong? I think this should be a localization, but I can not find how to confirm or change it.

Thank you.

Roman

manodwhb — Thu, 24 May 2018 07:14:22 GMT

@Romanesku,check the below way i could able to convert.

Romanesku — Thu, 24 May 2018 07:56:52 GMT

Hi Manohar,

thank you, I found where was the problem. On my PC is location Slovakia and the formats as well Slovak.

When I change the formats to the English for Europe, it start to work.

regards,

Roman