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

Add comment

biuquote
  • Comment
  • Preview
Loading

Calendar

<<  October 2026  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

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

"The distance between insanity and genius is measured only by success."
Bruce Feirstein