C # Regex Extract City, State zip from Address string

by ssi 1. May 2013 17:40
Useage:   string[] CityStateZip = GetCityStateZip(cus.ADD3);
 

private string[] GetCityStateZip(string sAddress)         {             //string[] split = sAddress.Split(new Char[] { ' ', });             //return split;             sAddress = sAddress.Replace(".""");             sAddress = sAddress.Replace(","", ");             sAddress = sAddress.Replace("  "" ");             string[] aRet = new string[3];             Regex addressPattern = new Regex(@"(?<city>[A-Za-z',.\s]+) (?<state>([A-Za-z]{2}|[A-Za-z]{2},))\s*(?<zip>\d{5}(-\d{4})|\d{5})");             MatchCollection matches = addressPattern.Matches(sAddress);             for (int mc = 0; mc < matches.Count; mc++)             {                 aRet[pADDR_CITY] = matches[mc].Groups["city"].Value;                 aRet[pADDR_STATE] = matches[mc].Groups["state"].Value;                  aRet[pADDR_ZIP] = matches[mc].Groups["zip"].Value;             }             return aRet;         }

Tags: , ,

Regex

Calendar

<<  May 2024  >>
MoTuWeThFrSaSu
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

RecentComments

None

Development Team @ Shelbysys

We develop custom database applications for our clients. Our development tool of choice is MS Visual Studio. 

Quotations

"A woman's guess is much more accurate than a man's certainty."
Rudyard Kipling