topic how to parse various date formats in Talend Studio

how to parse various date formats

Anonymous — Sat, 16 Nov 2024 07:19:43 GMT

hello community,

in my csv file i have three different date formats -> ("MM/dd/yyyy", "MM.dd.yyyy", "yyyy") as string values.

I wanted to use parsedate function in tMap.

First i did it like this: TalendDate.parseDate("MM.dd.yyyy",row1.birth_date);

and it works for one or more rows when it is only THIS format.

But as mentioned before I also need TalendDate.parseDate("MM/dd/yyyy",row1.birth_date); and

TalendDate.parseDate("yyyy",row1.birth_date);

How can I combine these three types? I tried to use +, && but it does not work.

Can someone help me out?

thanks in advance

lisua

Re: how to parse various date formats

ashif2 — Fri, 09 Nov 2018 18:30:06 GMT

Hi Lisua,

When we have multiple date formats on the same column, we should validate the date value by using isdate before parsing it to date .

!Relational.ISNULL(row1.birth_date)?
(TalendDate.isDate(row1.birth_date,"MM/dd/yyyy")?
TalendDate.parseDate("MM/dd/yyyy",row1.birth_date):
TalendDate.isDate(row1.birth_date,"MM.dd.yyyy")?
TalendDate.parseDate("MM.dd.yyyy",row1.birth_date):
TalendDate.isDate(row1.birth_date,"yyyy")?
TalendDate.parseDate("yyyy",row1.birth_date): null
):null

This logic will solve your problem.

If the answer has helped you, could you please mark the topic as resolved.