Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Contributor
4141 Points
931 Posts
Feb 29, 2012 12:47 PM|LINK
Try this:
Regex r = new Regex(".*\\[D\\].*", RegexOptions.IgnoreCase | RegexOptions.Multiline); MatchCollection mcInformation = r.Matches(originalText.ToString()); List<string> listInformation = new List<string>(); foreach (Match objM in mcInformation) { listInformation.Add(objM.ToString().Replace("\r","")); if (objM.ToString().Contains("START SHOP")) { Regex rStartDates = new Regex("((?:(?:[0-2]?\\d{1})|(?:[3][01]{1}))[-:\\/.](?:[0]?[1-9]|[1][012])[-:\\/.](?:(?:\\d{1}\\d{1})))(?![\\d])", RegexOptions.IgnoreCase | RegexOptions.Multiline); Match mStartDates = rStartDates.Match(originalText.ToString()); if (mStartDates.Success) { string strStartDate = mStartDates.Groups[0].ToString(); } } if (objM.ToString().Contains("STOP SHOP")) { Regex rStopDates = new Regex("((?:(?:[0-2]?\\d{1})|(?:[3][01]{1}))[-:\\/.](?:[0]?[1-9]|[1][012])[-:\\/.](?:(?:\\d{1}\\d{1})))(?![\\d])", RegexOptions.IgnoreCase | RegexOptions.Multiline); Match mStopDates = rStopDates.Match(originalText.ToString()); if (mStopDates.Success) { string strStopDate = mStopDates.Groups[1].ToString(); } } }
Sum8
Contributor
4141 Points
931 Posts
Re: Regex to find string in a text column
Feb 29, 2012 12:47 PM|LINK
Try this:
Regex r = new Regex(".*\\[D\\].*", RegexOptions.IgnoreCase | RegexOptions.Multiline); MatchCollection mcInformation = r.Matches(originalText.ToString()); List<string> listInformation = new List<string>(); foreach (Match objM in mcInformation) { listInformation.Add(objM.ToString().Replace("\r","")); if (objM.ToString().Contains("START SHOP")) { Regex rStartDates = new Regex("((?:(?:[0-2]?\\d{1})|(?:[3][01]{1}))[-:\\/.](?:[0]?[1-9]|[1][012])[-:\\/.](?:(?:\\d{1}\\d{1})))(?![\\d])", RegexOptions.IgnoreCase | RegexOptions.Multiline); Match mStartDates = rStartDates.Match(originalText.ToString()); if (mStartDates.Success) { string strStartDate = mStartDates.Groups[0].ToString(); } } if (objM.ToString().Contains("STOP SHOP")) { Regex rStopDates = new Regex("((?:(?:[0-2]?\\d{1})|(?:[3][01]{1}))[-:\\/.](?:[0]?[1-9]|[1][012])[-:\\/.](?:(?:\\d{1}\\d{1})))(?![\\d])", RegexOptions.IgnoreCase | RegexOptions.Multiline); Match mStopDates = rStopDates.Match(originalText.ToString()); if (mStopDates.Success) { string strStopDate = mStopDates.Groups[1].ToString(); } } }Sumit Pathak
------------------
ThisPost = Helped == True ? "Mark As Answer" : "Elaborate your problem in more details"