date Format YYYYMMDD check

vinodn · Post by **vinodn** » Thu Jul 31, 2008 4:53 am

Hi,

We need to check the date format in the source column,

If format is YYYYMMDD then we need to send to Target else reject the record,

Ex: data:20080927 ---it is fine
data:20082708----it is wrong
data:00000000----it is wrong

Let me know how to check this format,

mystuff · Post by **mystuff** » Thu Jul 31, 2008 5:31 am

I guess that would be a valid date, so you would need to have a special condition (ie. ignore 0000-00-00) apart from checking whether its a date.

As to know whether it is a date or not, there are date functions available, you could apply your own logic on them to know whether its a valid date or not.

ZDC · Post by **ZDC** » Thu Jul 31, 2008 6:15 am

how about this ...

If DateStr=DatetoString(StringtoDate(DateStr,"%yyyy%mm%dd"),"%yyyy%mm%dd") Then valid else invalid

chulett · Post by **chulett** » Thu Jul 31, 2008 7:02 am

Search the forums for the use of the "IsValid" function.

vinodn · Post by **vinodn** » Thu Jul 31, 2008 7:05 am

Hi,

Thanks for response,

here i need to load the data to target if format is YYYYMMDD only, otherwise need to reject ,

Let me know how to handle

chulett · Post by **chulett** » Thu Jul 31, 2008 7:07 am

Check to see if the date is valid or not, reject it if it is not.

Which part of that do you need help with?

vinodn · Post by **vinodn** » Thu Jul 31, 2008 8:11 am

chulett wrote: Check to see if the date is valid or not, reject it if it is not.

Which part of that do you need help with?

Hi Chulett,

Thanks for your's response,

I need how to check the date format and reject that record,

i tried with IsValid, it is not working,

ArndW · Post by **ArndW** » Thu Jul 31, 2008 8:16 am

IsValid() is the correct route to take. What isn't working with that function?

sankar.td · Post by **sankar.td** » Mon Feb 16, 2009 12:20 am

Hi All,

With out writing any logic in transfomer stage,we can reject the records which not matching to our date format by using sequential file itself.

If we goto "FORMAT" TAB in seqential file there we have to mention our required date format.so that it will reject the records which not matching to the our specified format.

kailas · Post by **kailas** » Mon Feb 16, 2009 4:33 am

Hi sankar ,

I just tried using the date format in sequential file under [b]Type defaults [/b]option by giving a date format other then the incomin format ..

But when i run the job i saw that it make no difference and all records go to the destination file. I think it will not consider that format coz that is used only in case of Type Default cases.

plz try ur self once

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 16, 2009 6:17 am

Give some example of good and bad values. Also provide the format mask you tried.