Remove line breaks and spaces from Table field
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.