Multiple date possibilities in Talend Schema

LDPtechAFB — Sat, 16 Nov 2024 01:45:56 GMT

Hello, I'm trying to extract some dates from files but the date format could change between theses files.

How can I put differents date model in my schema ?

for example : file 1 (format date)

"yyyy-MM-dd'T'HH:mm:ssXXX"

file 2 (format date) :

"yyyy-MM-dd'T'HH:mm:ss.SSSSSSSXXX"

i looked some regex stuff and i did a thing that looks like :

[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9].*[0-9]*[0-9]*\+[0-9][0-9]:[0-9][0-9]

but i cannot implement this kind of datas.

Could you explain me how to solve my problem ?

Regards

Re: Multiple date possibilities in Talend Schema

Anonymous — Mon, 03 Aug 2020 06:52:58 GMT

It is impossible to defined multiple date pattern on schema. The workaround is to read the value as a string from file, then check the length of string, and use different date pattern to parse the string and convert it to a Date in the job.

Regards

Shong

topic Multiple date possibilities in Talend Schema in Talend Studio

Multiple date possibilities in Talend Schema

Re: Multiple date possibilities in Talend Schema