Check date format and parse string to a date

Anonymous — Mon, 06 Feb 2017 20:36:19 GMT

I have a column with values like '20170128' , '20170129' , etc....
I am trying to find if the values follow the order "yyyyMMdd" and if at all they follow, insert as it is, else insert a null value.
say e.g.
20170128 - 20170128
20172801 - NULL
TalendDate.isDate(row1.Column2,"yyyyMMdd")?TalendDate.parseDate("yyyyMMdd",row1.Column2):""
I used the above mentioned condition to list out the values in tMAP component.

But I get an error like
"type mismatch cannot convert from object&serializable&comparable to date"

Can anyone please tell me what is the error in the above condition ?

Thanks in advance..

Re: Check date format and parse string to a date

Anonymous — Tue, 07 Feb 2017 03:37:51 GMT

Hi
If the data type of output column is Date, try to change the expression to:
TalendDate.isDate(row1.Column2,"yyyyMMdd")?TalendDate.parseDate("yyyyMMdd",row1.Column2):null

Regards
Shong

topic Check date format and parse string to a date in Talend Studio

Check date format and parse string to a date

Re: Check date format and parse string to a date