Space in addresses

Question

Anyone have a solution for random spaces in line 2 of the addresses? For some reason some of the addresses in our database have random spaces below the address and I am not sure how to run a query to find all of them and fix them. Has this happened to anyone?

Abby Lau · Answer

Alright that's fine, for the most part it seems like the plugin does the job, just wanted to see if there is a way to regularly check for these errors. Thank you so much for your help Joe!

Joe Moretti · Answer

I think with the example you are showing, will not work, since the line that has a space is Address line 2. You are better off using the plugin, since it will deal with all various kind of issues, where there is a blank line.

Abby Lau · Answer

Thanks Joe! The plugin worked but trying your query I don't think it fully isolates and captures the issue. For example the issue I am having is that addresses are showing up like this, with a space between the address and city:

Address Line 1

City

Province  Postal Code

Your query would show me both entries that look like that and regular entries that don't have line 2. Most of the time we don't use line 2 or 3. Would you be able to help me with figuring out a query that only shows me the addresses with issues?