How to skip transformation errors in the reformat component?

tav

• June 30, 2009 00:00

• Answered

Follow

How do I skip a transformation error in a Clover reformat component? I specified MIN_INT=CONTINUE; in the error action but that does not seem to be working. I am doing a str2date transformation and I would ideally like to skip any bad values before I insert this into the database. How can I achieve this?

Thanks

TAV

• 

  avackova

  • July 01, 2009 06:56

  0

  Comment actions Permalink

  Hello,
  it should work. Do you remember to return -1 from your transformation function if the string can't be converted?
• 

  tav

  • July 02, 2009 03:33

  0

  Comment actions Permalink

  Currently I am getting a Clover exception (I am trying to do a str2date(date,'yyyy-mm-dd-hh:mm:ss'), is there any way I can catch this and return -1? or if I set teh default return to -1 I will get a return of -1 when an exception occurs?
  
  Thanks
  
  TAV
• 

  avackova

  • July 02, 2009 07:11

  0

  Comment actions Permalink

  Hello TAV,
  catching exception is not possible in CTL. You can use is_date function, before converting or try_conver function instead of str2date. Another solution is to write your transformation in java.

Please sign in to leave a comment.