Python regex to match dates

by

Instead of using regex, it is generally better to parse the string as a datetime.datetime object:

In [140]: datetime.datetime.strptime("11/12/98","%m/%d/%y")
Out[140]: datetime.datetime(1998, 11, 12, 0, 0)

In [141]: datetime.datetime.strptime("11/12/98","%d/%m/%y")
Out[141]: datetime.datetime(1998, 12, 11, 0, 0)

You could then access the day, month, and year (and hour, minutes, and seconds) as attributes of the datetime.datetime object:

In [143]: date.year
Out[143]: 1998

In [144]: date.month
Out[144]: 11

In [145]: date.day
Out[145]: 12

To test if a sequence of digits separated by forward-slashes represents a valid date, you could use a try..except block. Invalid dates will raise a ValueError:

In [159]: try:
   .....:     datetime.datetime.strptime("99/99/99","%m/%d/%y")
   .....: except ValueError as err:
   .....:     print(err)
   .....:     
   .....:     
time data '99/99/99' does not match format '%m/%d/%y'

If you need to search a longer string for a date,
you could use regex to search for digits separated by forward-slashes:

In [146]: import re
In [152]: match = re.search(r'(\d+/\d+/\d+)','The date is 11/12/98')

In [153]: match.group(1)
Out[153]: '11/12/98'

Of course, invalid dates will also match:

In [154]: match = re.search(r'(\d+/\d+/\d+)','The date is 99/99/99')

In [155]: match.group(1)
Out[155]: '99/99/99'

To check that match.group(1) returns a valid date string, you could then parsing it using datetime.datetime.strptime as shown above.

More Related Contents:

  1. How to use a variable inside a regular expression?
  2. Match a whole word in a string using dynamic regex
  3. Case insensitive regular expression without re.compile?
  4. Python string.replace regular expression [duplicate]
  5. Split a string at uppercase letters
  6. Regex matching 5-digit substrings not enclosed with digits
  7. How to split but ignore separators in quoted strings, in python?
  8. How do I validate a date string format in python?
  9. BeautifulSoup – search by text inside a tag
  10. Python module to change system date and time
  11. Get the string within brackets in Python
  12. Regex for existence of some words whose order doesn’t matter
  13. Split string on commas but ignore commas within double-quotes?
  14. python date of the previous month
  15. Pandas – Number of Months Between Two Dates
  16. Add one year in current date PYTHON
  17. Python regex: splitting on pattern match that is an empty string
  18. Regular expression parsing a binary file?
  19. Remove duplicate chars using regex?
  20. Match any unicode letter?
  21. How to convert integer into date object python?
  22. Convert month int to month name in Pandas
  23. How can I make multiple replacements in a string using a dictionary?
  24. Python regex split without empty string
  25. Warning raised by inserting 4-byte unicode to mysql
  26. Convert string into Date type on Python [duplicate]
  27. How to use str.contains() with multiple expressions in pandas dataframes
  28. match dates using python regular expressions
  29. How to Fix JSON Key Values without double-quotes?
  30. python regular expression across multiple lines

Leave a Comment