Finding Duplicate Commans in Lines
Posted: Fri Mar 24, 2006 7:42 pm
Hello,
I'm trying to import a mailing list of 20K entries into a new program and I receive this error when importing my csv file:
warning: Read wrong fields number count: '3' expected 2
Since I only have 2 fields in the list (email/name), I'm assuming that some of my entries have more than 1 comma in them. I have removed all of the double entries ",," but I cant figure out how to find duplicate comma entries which are probably listed like this:
anyo,ne@yahoo.com,John
Does anyone know how I can find these duplicate commas?
Thanks!
I'm trying to import a mailing list of 20K entries into a new program and I receive this error when importing my csv file:
warning: Read wrong fields number count: '3' expected 2
Since I only have 2 fields in the list (email/name), I'm assuming that some of my entries have more than 1 comma in them. I have removed all of the double entries ",," but I cant figure out how to find duplicate comma entries which are probably listed like this:
anyo,ne@yahoo.com,John
Does anyone know how I can find these duplicate commas?
Thanks!