parsing fields of log files from error port.

etlnewbie

• April 08, 2010 00:00

• Answered

Follow

The logs returned when setting the reader data policy to "controlled" consist of four fields (incorrect record, number of incorrect field, incorrect record, error message). Is there a quick way to return just the "incorrect_record" field. I'm having a hard time trying to parse the logs since each error record from the logs span multiple lines.

• 

  avackova

  • April 09, 2010 12:22

  0

  Comment actions Permalink

  Can you clarify your problem? In the transformation downstream you can work with the field, that contains incorrect record, only, eg. in DataReader:
  

  fileURL=port:$0.offendingValue:discrete

  or in Reformat:
  

  function parseIncorectRecord(incValue){
  	......
  }
  
  // Transforms input record into output record.
  function transform() {
  	parseIncorectRecord($offendingValue);
  }

Please sign in to leave a comment.