Here is my concern. I have an address field with house number, street name and street type, like this: 100 Main St.
Sometimes, when I import addresses, there are spaces at the beginning or at the end of the address, as well as more than one space between the street number and the street name. A...