egress-ip-ranges.csv is corrupt

As of July 6th until July 13th there are 5 rows that have a 6th column.

There are 4 rows that have an extra row (I believe these are cloudflare IPs).

104.28.4.92/32,AU,,Newcastle, Nsw,	
104.28.4.91/32,AU,,Newcastle, Nsw,	
104.28.4.81/32,LB,,Beirut, Lebanon,
104.28.4.82/32,LB,,Beirut, Lebanon,

vs.

146.75.228.14/31,BS,,,
146.75.228.16/31,BS,BS-NP,NASSAU,
146.75.228.18/31,BZ,,,

Simple check to show commas per line. The 3 0s are blank lines which most CSV parsers handle gracefully. Most lines have 5 commas, but there are a few with 6.

awk -F ',' '{print NF}'  egress-ip-ranges.csv | sort | uniq -c
      3 0
  17675 5
      4 6
egress-ip-ranges.csv is corrupt
 
 
Q