topic Re: [resolved] String to date conversion Unparsable date:"" in Talend Studio

[resolved] String to date conversion Unparsable date:""

Anonymous — Thu, 06 Oct 2016 07:40:29 GMT

Hi,
I have string value of date "yyyy-MM-dd'T'hh:mm:ss'.'SSS'+'SSSS" (guessed pattern for 2015-11-18T06:24:26.000+0000 value) and i want to convert into date with pattern "dd/MM/yyyy HH:mm:ss" in tmap.
Give me the expersion to be used in tmap
I tried [font=Verdana, Helvetica, Arial, sans-serif]TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row4.LastViewedDate) in tmap[/font]
[font=Verdana, Helvetica, Arial, sans-serif]I'm getting errors like[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Unparseable date : ""[/font]
[font=Verdana, Helvetica, Arial, sans-serif]and[/font]
[font=Verdana, Helvetica, Arial, sans-serif]Unparseable date: "2016-05-04T12:39:46."
[/font]
[font=Verdana, Helvetica, Arial, sans-serif]thanks in advance..[/font]
[font=Verdana, Helvetica, Arial, sans-serif]VK[/font]

Re: [resolved] String to date conversion Unparsable date:""

Anonymous — Sat, 08 Oct 2016 01:31:30 GMT

Hi,
Could you please show us your tMap editor screenshot?

Best regards
Sabrina

Re: [resolved] String to date conversion Unparsable date:""

vapukov — Sat, 08 Oct 2016 02:24:41 GMT

TalendDate.parseDate( "yyyy-MM-dd'T'HH:mm:ss.SSSZ",row3.newColumn)
must help

Re: [resolved] String to date conversion Unparsable date:""

Anonymous — Sat, 08 Oct 2016 13:52:52 GMT

Thank you so much.... It works....