[Mailman-Users] isolating subscribers with Name provided

[E Publisher]

Oh boy, one of our administrators made a big mistake and thought they were changing subscribers email addresses by entering the new address into the Name field (which sits underneath each subscriber's email address in the Membership List screen).

So now, we've got about 200 incorrect subscriptions that need to be found and fixed. There's no record of the ones that were changed this way so we can't easily find and fix them.

All other subscribers have empty Name fields, so I was wondering if their is a way to search the entire list to isolate only those subscribers with something in the Name field. Like a database query or something along those lines.

Any ideas?