AnsweredAssumed Answered

House Numbers in Address Field

Question asked by d.justins on Jan 20, 2010
Latest reply on Jan 20, 2010 by mrvodka

Title

House Numbers in Address Field

Post

Hi all,

 

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. 

 

Thanks

 

- justin

Outcomes