regex for dates of different formats

Question

Files contain date formats 4 types:

31.12.2017 23:59:59 31-12-2017 23:59:59 2017.12.31 23:59:59 2017-12-31 23:59:59

How to filter the necessary using regex?

I tried to use

 [\d-\.]+ [\d:]+

Since, by analogy, I had a regex for the format of 2017-12-31 24:59:59

 [\d-]+ [\d:]+

But python gives the error:

 raise error, v # invalid expression sre_constants.error: bad character range

How to fix regex?

Instead of an explicit complex regular expression, you can use the datetime.strptime to check the dates or a simple regex + datetime constructor as shown in the links.

koshachok koshachok 528 five 23 · Accepted Answer · 2017-09-06T21:34:08

This regular expression divides the date into 4 groups: the first three are the date, the fourth is time (note that it is not parsed, that is, it is str = "24:59:59" ):

 (\d+)[\.|\-](\d+)[\.|\-](\d+)\s(.*) #Первый вариант (\d{2,4})[\.|\-](\d{2})[\.|\-](\d{2,4})\s(.*) #Второй вариант

If you want to catch exactly the dates of this format 2017-12-31 24:59:59, then:

 (\d{4})\-(\d{2})\-(\d{2})\s(.*)

And just in case, leave it here.

You mean that you can also parse it, but I propose to do this to you, on the Internet a lot of online services for composing regular expressions.
Look at the date and do it by analogy, there will be questions - ask, but the main thing is that you learn how to work with it.

regex for dates of different formats

1 answer 1

More articles: