eg. JBB Inc. Headquarters 20 West RiverCenter Blvd Covington KY 41011 USA
Asked
Active
Viewed 1,074 times
-5
-
1Required steps: 1. Read this: http://stackoverflow.com/help/how-to-ask 2. Try something yourself. 3. Come back and edit your question with things you've tried so far. 4. Wait for a response. This question is exactely: How to NOT ask a question on SO. – Complexity Feb 23 '15 at 10:57
-
Did you google it first? – Raging Bull Feb 23 '15 at 10:57
2 Answers
0
You can use the Split method of the string. ex: Address.Split(" ".ToCharArray()) // Address is a property of type string.
0
Addresses are all so vastly different that you will never simply be able to split a string into the correct parts. Rather capture the address as separate fields, or at least have comma's to separate fields.
If your addresses seem to be captured in a similar format you could create a function in code that could solve the majority (but probably not all) rows.
![](../../users/profiles/556325.webp)
Brendan
- 1,217
- 1
- 15
- 34