topic Re: Unparseable date error in Talend Studio

Unparseable date error

Anonymous — Thu, 24 May 2018 06:55:46 GMT

I am getting "Unparseable date" error by using the below code.

"".equals(ColName) || ColName == null ? "" : TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("MM-dd-yyyy","ColName"))

Input is "Date" type, i am converting it to String type. I am also trying to replace null with blank values

manodwhb — Thu, 24 May 2018 07:11:43 GMT

@samisyed80,what is the source date format? do you just need to convert date to string?

Anonymous — Thu, 24 May 2018 07:21:26 GMT

Source is DATE type, format "MM-dd-yyyy"

Destination is STRING type "yyyy-MM-dd"

manodwhb — Thu, 24 May 2018 07:37:22 GMT

@samisyed80,to convert date from one format to another use below way. are you loading to excel file out it doesnt matter sting or date

Anonymous — Thu, 24 May 2018 07:41:38 GMT

My source is Date type. but your example is having string type in source. Is that going to impact?

manodwhb — Thu, 24 May 2018 07:46:46 GMT

@samisyed80,sorry,previous worng screenshot.

find teh correct one.

Anonymous — Thu, 24 May 2018 08:14:46 GMT

OK, now, i don't want null in this column, how to replace it with SPACE or BLANK?

manodwhb — Thu, 24 May 2018 08:17:35 GMT

@samisyed80,use this way

"".equals(ColName) || ColName == null ? "" : ColName

Anonymous — Thu, 24 May 2018 08:25:43 GMT

Some of the date rows are having null. If i put that code to replace with BLANK's then Cant convert String to Date error is throwing.

manodwhb — Thu, 24 May 2018 08:28:39 GMT

try the below one.

manodwhb — Thu, 24 May 2018 09:09:24 GMT

@samisyed80,still do you have issue?

Anonymous — Thu, 24 May 2018 11:19:15 GMT

Yes Manohar, it didnt work.

Also, the output table should store the date in "yyyy-mm-dd" format.