Regex to extract date time from given string

Question

I want to extract date from the string through regex.

String : log-bb-2014-02-12-12-06-13-diag

How to do it?

How about just split your string with - and concatenate items which they contains only numbers? — Soner Gönül
– Soner Gönül, Commented Feb 12, 2014 at 9:29
@ManishTiwari what should be the date in the string you have mentioned ? is it 12th feb 2014 or 12th june 2013 ? — aelor
– aelor, Commented Feb 12, 2014 at 9:39

Alberto · Accepted Answer · 2014-02-12 09:45:31Z

13

Here something to start:

string s = "log-bb-2014-02-12-12-06-13-diag";
Regex r = new Regex(@"\d{4}-\d{2}-\d{2}-\d{2}-\d{2}-\d{2}");
Match m = r.Match(s);
if(m.Success)
{
    DateTime dt = DateTime.ParseExact(m.Value, "yyyy-MM-dd-hh-mm-ss", CultureInfo.InvariantCulture);
}

answered Feb 12, 2014 at 9:45

Alberto

16k9 gold badges49 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Slai Over a year ago

@"\d{4}(-\d\d){5}"

Anonymous Person Over a year ago

System.Globalization.CultureInfo.InvariantCulture

VSO Over a year ago

The using statement is using System.Text.RegularExpressions;

Vignesh Kumar A · Accepted Answer · 2014-02-12 09:46:39Z

11

Try this

(\d+)[-.\/](\d+)[-.\/](\d+)

Regex Demo.

It will match all date formats

answered Feb 12, 2014 at 9:46

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Comments

aelor · Accepted Answer · 2014-02-12 09:46:13Z

3

Considering your date to be just 2014-02-12 i.e. 12th feb 2014.I hev written the below code to extract that part using ruby

str = 'log-bb-2014-02-12-12-06-13-diag'

str.scan(/\d{4}.\d{2}.\d{2}/)

will return ["2014-02-12"]

regex is written within two /

\d means any integer, {} curly braces with any integer means number of times it has been repeated, . means any character. Here I have used it for -

answered Feb 12, 2014 at 9:46

aelor

11.2k3 gold badges35 silver badges48 bronze badges

Comments

EdwardFunnyHands · Accepted Answer · 2022-03-03 10:29:03Z

0

I have checked all above suggestions but none worked for if date format is "November 11, 2000". As this was a constant format that I need to extract for my problem here is the solution for it.

[A-Z]\w*\s\d*\W*\d{4}

Note: This regex is specifically to extract date in the above mentioned format, if the order is randomized for eg. "11 November, 2000". This Regex won't give suitable result. However slight modification in the above re, would give proper results.

answered Mar 3, 2022 at 10:29

EdwardFunnyHands

1733 silver badges11 bronze badges

Collectives™ on Stack Overflow

Regex to extract date time from given string

4 Answers 4

3 Comments

Regex Demo.

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Regex Demo.

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related