SIMS Reporting on Email Address contents
Say I have a couple of thousand email addresses in SIMS, entered by people with varying levels of understanding what an RFC-compliant email address looks like.
Is there any way (using built-in SIMS tools or read-access to the database) I can search through them all and flag up any that are broken? Writing my own rules as to "broken" is fine - I just want a way of weeding out commas, "binternet", multiple @ etc without manually* reviewing everything.
(And yes, I have submitted a Feature Request because Capita's idea of "checking email addresses" seems to consist of "does it have an @ and something after the dot?").