Page 1 of 1

Finding Duplicate Commans in Lines

Posted: Fri Mar 24, 2006 7:42 pm
by bad959fl
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!

Posted: Fri Mar 24, 2006 8:10 pm
by ben_josephs
Find what: ,.*,

[X] Regular expression

Mark All
The .* part of the regular expression matches any sequence of characters (except newline).