TalendDate.parseDate: Unparseable date only for "May"

Six Stars

TalendDate.parseDate: Unparseable date only for "May"

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 


Accepted Solutions
Six Stars

Re: TalendDate.parseDate: Unparseable date only for "May"

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

  


All Replies
Thirteen Stars

Re: TalendDate.parseDate: Unparseable date only for "May"

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

 

Untitled.pngUntitled.png

Manohar B
Six Stars

Re: TalendDate.parseDate: Unparseable date only for "May"

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