>I have a character column in the database in this format:
>
>10:00 AM
>
>How can I get hour and minute from it?
>
>Thanks in advance.
>
>I found this RegEx pattern
>
>(1[012]|[1-9]):[0-5][0-9](\\s)?(?i)(am|pm)
>
>but how should I use it to get my groups?
This is what I came out so far - does it look correct?
String cRegEx = "(1[012]|[1-9]):[0-5][0-9](\\s)?(?i)(am|pm)";
MatchCollection matches = Regex.Matches("10:00 AM", cRegEx, RegexOptions.IgnoreCase);
foreach (Match m in matches)
{
Console.WriteLine(m.Groups[0]);
Console.WriteLine(m.Groups[1]);
Console.WriteLine(m.Groups[2]);
}
If it's not broken, fix it until it is.
My Blog