Unanswered posts

#1 2008-02-21 15:11:41

mzk
New member
Registered: 2008-02-20
Posts: 8

SchemaComplianceCheck

I have a delimited file which contains dates of the format "dd/MM/yyyy".

When a date is missing/null, the file contains "00/00/0000" so I have used the replace component to change to "".

However, the compliance check rejects with "Date format not valid" - the fields are flagged as nullable with the "dd/MM/yyyy" date pattern.

I've seen other posts with a link to a bug regarding checking null before attempting to parse the date, but the bug is shown as fixed in v2.2.5 - I'm using TOS 2.3.0.

Any thoughts anyone?

Offline

#2 2008-02-21 23:15:43

mhirt
Talend team
Registered: 2006-09-19
Posts: 1638

Re: SchemaComplianceCheck

Hello,

In this case, this is really not a bug.
"" is clearly not a date and it's not matching the "dd/MM/yyyy" pattern.

Regards,

Offline

Board footer

Powered by FluxBB