Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Romanesku
Contributor III
Contributor III

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 

Labels (4)
1 Solution

Accepted Solutions
Romanesku
Contributor III
Contributor III
Author

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

  

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

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

 

0683p000009LxAV.png0683p000009LxJH.png

Romanesku
Contributor III
Contributor III
Author

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