Tag Archives: replace

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.