title: Filtering file in unix using grep/sed/awk other?
body: <p>I have gigantic error log files that show errors encountered on a dataload.</p>
  
  <p>I need to report errors that are NOT unique constrain violations, but searching through the files manually are impractical due to their size.</p>
  
  <p>The log file:</p>
  
  <pre><code>Record 1: Rejected - Error on table DMT_.
  ORA-00001: unique constraint (DM.DMT__PK) violated
  
  Record 2: Rejected - Error on table DMT_.
  ORA-01400:cannot insert NULL in to("DM"."DMT_INSURANCE"."INSURANCE_FUND_CODE")
  
  Record 3: Rejected - Error on table DMT_.
  ORA-00001: unique constraint (DM.DMT__PK) violated
  
  Record 4: Rejected - Error on table DMT_ADDRESS, column ORIGINAL_POSTCODE.
  ORA-12899: value too large for column "DM"."DMT_ADDRESS"."ORIGINAL_POSTCODE" (actual: 12, maximum: 10)
  </code></pre>
  
  <p>Desired output file is</p>
  
  <pre><code>Record 2: Rejected - Error on table DMT_.
  ORA-01400:cannot insert NULL in to("DM"."DMT_INSURANCE"."INSURANCE_FUND_CODE")
  
  Record 4: Rejected - Error on table DMT_ADDRESS, column ORIGINAL_POSTCODE.
  ORA-12899: value too large for column "DM"."DMT_ADDRESS"."ORIGINAL_POSTCODE" (actual: 12, maximum: 10)
  </code></pre>
  
  <p>I'm pretty sure this can be done in grep, sed or awk, but I'm new to this sort of thing...I'd really appreciate a pointer or two.</p>