Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2008-10-08 : 10:33:10
|
| does anybody have any code to parse an addressexample: 111 MAIN STREET should parse 111 into street number field and MAIN into street name field and STREET should go to street suffix field.Address can also include post and pre directionexample275 w main st |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 10:35:02
|
| What all will be formats in which address comes? will they be consistent? |
 |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-10-08 : 10:47:12
|
| the address will not be the sameexamples are585 GARYS DR1224 MAIN ST APT 2C45 W OLD MILL TRL40480 N LAKE SHORE DR791 ANITA AVE APT 201292 ANITA TER APT 202801 RINEAR RD |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 10:49:57
|
| which column should W,N,... go? |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-10-08 : 11:05:31
|
| 585 GARYS DR -> 585 into street no, GARYS into street name1224 MAIN ST APT 2C-> 1224 into street no, MAIN into street name, 45 W OLD MILL TRL -> 45 into street no, OLD MILL into street name40480 N LAKE SHORE DR -> 40480 into street no, LAKE SHORE into street name791 ANITA AVE APT 201-> 791 into street no, ANITA into street name,801 RINEAR RD -> 801 into street no, RINEAR into street nameI need only the street no and street name into fields, remaining i can ignore |
|
|
|
|
|
|
address parser