topic Re: Date Datatypes in Talend Studio

Date Datatypes

lmit — Thu, 18 Aug 2022 15:30:43 GMT

Hi All,

My Input file has data like

jun-2022

jun

18-jun-2022

is it possible to make my output as

1-jun-2022

18-jun-2022

If the above the out is not possible can i have get my output as

null

18-jun-2022

if the format is not correct it has to be null

The column datatype in input file is string

Can anyone suggest solution

Thanks in advance,

lmit

Anonymous — Fri, 19 Aug 2022 02:02:49 GMT

You can call the built-in function TalendDate.isDate() to check the format on tMap and output different value based on the result.

TalendDate.isDate(row1.data, "dd-MMM-yyyy")?row1.data:null

Regards

Shong

lmit — Fri, 19 Aug 2022 18:21:07 GMT

Thanks shong , it worked