|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Parsing address
hi, im running into a bit of a problem. i will like to string parse the street name into what you see below using DTS. How can i get around this?
12 north plaza boulevard apt.16 12|N|plaza blvd| apt16 |
|
#2
|
|||
|
|||
|
12 north plaza boulevard apt.16
i want to split the address and put it into multiple fields. address_number 12 suffixA North street_name plaza blvd suffixb apt16 anyone can help? |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Parsing address |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|