Unparsable date using Tmap

[Anonymous]

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.

[Anonymous · Accepted solution]

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("\"", "")