Finding Duplicate Commans in Lines

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, MudGuard

Post Reply
bad959fl
Posts: 21
Joined: Wed Jun 15, 2005 11:32 pm

Finding Duplicate Commans in Lines

Post 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!
ben_josephs
Posts: 2464
Joined: Sun Mar 02, 2003 9:22 pm

Post by ben_josephs »

Find what: ,.*,

[X] Regular expression

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