wamap
Last Activity: Feb 8 '11, 10:09 PM
Joined: Dec 29 '10
Location:
-
Yes the link to the website works. Thanks. -
Thanks but the link you sent is either missing, deleted or cant be found.Leave a comment:
-
I intend to do this with SQL Server Management Studio.Leave a comment:
-
I hope this explains in details my aims.
Dataset sample -
609 14th st. NW
6115 NW Campbell River Blvd Suite 108
61346 John Doe NE
a. First column with only contain the street Number until it find a space that separate the number and the strings in the address column. As in the case above , the result will be
StreetNo
1. 609
2. 6115
3. 61346
b. Second. The...Leave a comment:
-
Thanks. But the issue is the address number vary from one nemeric value to six numeric values.Leave a comment:
-
Street Address Clean up using sql server
Hello ,
Can any one assist. I have a Street Address file and i want to split the information in the file into different columns.
For example "100 SW 14th Street N, Suite 120"
First. The script will capture the 100 into a new column called StreetNo. Was thinking of a scenario where the script does a count until it finds a space then stops.
Second. The script will extract "SW"...
No activity results to display
Leave a comment: