Unparsable date using Tmap

Anonymous — Fri, 29 Nov 2019 12:49:05 GMT

Hello guys,

How you are ?

I'm facing a issue when i trying to parse a String column to Date. The error name is Unparseable date "11/28/2019" "7:12:09: AM"

The column is "REQDTHR"

With tMap i'm using the expression bellow

And when i run my job i receive this error mensage

I don't need the time just from the date, knowing this I tried using String.format ("% 10s", row5.REQDTHR) EREPLACE too, but nothing is working to remove these quotes correctly.

Thanks for listening.

I appreciate any help.

Re: Unparsable date using Tmap

Anonymous — Fri, 29 Nov 2019 15:01:44 GMT

This is being caused by the double quotes you have inside your date. For example....

11/28/2019"  "7:12:09 AM

A way you get round this is to use the code below inside your parseDate method instead of row5.REQDTHR

row5.REQDTHR.replaceAll("\"", "")

topic Re: Unparsable date using Tmap in Talend Studio

Unparsable date using Tmap

Re: Unparsable date using Tmap