by ssi
10. June 2016 07:51
public static string StripLeadingZeros(string sAlphaNumberText)
{
/*
* That will trim trailing zeros if they appear after the period in a decimal number (it will always leave a single zero).
* It also accounts for numbers that appear at the very end.
*/
string sRet = "";
sRet = Regex.Replace(sAlphaNumberText,
@"(?<=\.\d+?)0+(?=\D|$)",
String.Empty);
return sRet;
}
public static string StripWhitespace(string sAlphaNumberText)
{
/*
* sStrip Whitespace
*/
string sRet = "";
sRet = Regex.Replace(sAlphaNumberText, @"\s+", "");
return sRet;
}
public static string StripAllButNumbers(string sAlphaNumberText)
{
/*
* strip all characters except numbers
*/
string sRet = "";
sRet = Regex.Replace(sAlphaNumberText, @"[^\d]", String.Empty);
return sRet;
}
public static string StripNumbers(string sAlphaNumberText)
{
/*
* sStrip Numbers
*/
string sRet = "";
sRet = Regex.Replace(sAlphaNumberText, @"[\d-]", string.Empty);
return sRet;
}
public static string StripAllSpecialCharacters(string sAlphaNumberText)
{
/*
* Strip All Special Characters
*/
string sRet = "";
sRet = Regex.Replace(sAlphaNumberText, "[^0-9a-zA-Z]+", "");
return sRet;
}
by ssi
17. December 2015 17:43
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;
}
3bf98b88-7c54-49c8-96ae-9def48f1fa71|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: REGEX
CSharp | Regex
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;
}
a6fe347d-d67d-42ce-993e-187cc54406c6|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: regex, array, match
Regex