House Numbers in Address Field
I have alot of data that was imported into the database i am working with and someone didn't set it up right initiallly, so now i have the street numbers in front of the street name in the same field. They are separated with a space. I'm sure it's simple, but i need some direction. I was wondering if it is possible to separate the house number from the street name using a script. I can figure out the loop and everything, i'm just not certain of the functions needed to do this.