How to automatically remove all unacceptable entries from a CSV file?

[geercom]

I have an enormous contacts file in .CSV format with about 15,200 entries. Many entries are nonstandard, repeating the email address in the first name field or something like this. I want to automatically remove all of these nonstandard entries and leave all the ones that have a First and last name and an email address in their appropriate fields. How do you do this?

To make sure you understand the question, here's an illustration:

First Name Last Name Email Address

Bob Smith Bob@Smith.com {this is an example of a good, acceptable, "standard" (as I am using the word) entry}

Bob@Smith.com Bob@Smith.com {this is an example of an unacceptable entry of the kind I would like to remove}

And anything that does not follow the first example would also be nonstandard.

How do I remove all the nonstandard ones all at once?

 

[bukimi]

I'm quite convinced Excel can't recognize it data in cell is a "name" or not. It can only detect all non-standard entries if you define them.
For example, you can make Excel check if @ is added in First name or Last name instead of e-mail address, but then if someone adds # instead of @ it will be marked as OK (unless you define ALL possible mistakes).

 

[oldbrewer]

	first space	second space	"@"	decision
Bob Smith Bob@Smith.com	4	6	14	KEEP
Bob@Smith.com Bob@Smith.com	14	100	4	REMOVE
BobSmith Bob@Smith.com	9	100	13	REMOVE
BobSmithBob@Smith.com	#VALUE!	100	12	REMOVE
Bob@Smith.com	#VALUE!	100	4	REMOVE
	by finding where the first space is, where the second space is,
	and where the @ is
	putting 100 if there is no second space
	and checking if the @ occurs after a second space
	you get the ones to remove
	these helper columns can be hidden away to the right

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>