Python script to check for mismatched number of Columns in a CSV file. Useful for checking files before loading into ServiceNow because SN doesn't tell you what line number had a mismatch, it just rejects the whole file.

CSV Delimiter Check.py

#! /usr/bin/env python 
import fileinput 
import sys 
  
headerColCnt = 0
mismatches = 0
delimiter = "|"
  
def process(line): 
    global headerColCnt 
    global mismatches 
  
    if fileinput.lineno() == 1: 
        headerColCnt = line.count(delimiter) 
        print ("Columns in Header: ", headerColCnt) 
    else:    
        if line.count(delimiter) != headerColCnt: 
            print ("Mismatched Column # on line: ", fileinput.lineno()) 
            mismatches += 1
  
for line in fileinput.input(openhook=fileinput.hook_encoded("utf8")): 
    process(line) 
  
print ( "Lines processed.", fileinput.lineno() ) 
print ( "Mismatches found.", mismatches )