Usage: ./show-invalid-csv-lines.py <filename.csv>

show-invalid-csv-lines.py

#!/usr/bin/env python
import sys


DELIMITER = '|'
line_number = 0

with open(sys.argv[1], 'r') as fh:
  header = fh.readline()
  delim_in_header = header.count(DELIMITER)
  line_number += 1

  for line in fh.readlines():
    line_number += 1
    delim_in_line = line.count(DELIMITER)
    if delim_in_header != delim_in_line:
      print '%d: Wrong number of delimiters (%d), %d expected!' % (
        line_number, delim_in_line, delim_in_header)
      print line