eg. JBB Inc. Headquarters 20 West RiverCenter Blvd Covington KY 41011 USA
Asked
Active
Viewed 1,513 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.

Brendan
- 1,237
- 1
- 16
- 34