Had an issue with a huge table of email address not really compliant. Some had trailing/ending spaces, others even line breaks. To fix the line breaks, this worked:
update emails_table set email = replace(email, ‘\n’, ”)
To remove trailing/ending spaces, i used this:
update emails_table set email=trim(email)
Go and be happy.