Regular Expressions 101

guif

Ref: https://rgxdb.com/r/526K7G5W

Date match on multiple formats

Get date from string

Convert your date from yyyy-mm-dd to mm/dd/yyyy and your time from hour:minute:second to hour:minute. You can manipulate the data further with your own function.

yyyy/mm/dd

mm/dd/yyyy

dd/mm/yyyy

Convert a US Date format to ISO

this regex check if the date is in the format d/m/Y H:i , it will not check the number of days in month

Rip apart a date-time and reassemble the parts.

^(((\d{3}1-9]|\d{2}[1-9]\d|\d[1-9]\d{2}|[1-9]\d{3})(\/)(((0[13578]|1[02])(\/)(0[1-9]|[12]\d|3[01]))|((0[469]|11)(\/)(0[1-9]|[12]\d|30))|(02(\/)(0[1-9]|[1]\d|2[0-8]))))|(((\d{2})(0[48]|[2468|13579)|((048]|[2468|3579)00))(\/)02(\/)29))$ Match year/month/day, date format. E.g: 2021/08/25 [match] 2021/...

file_(name)|file_(path)|file_(size)|file_(date) - searching (regex rule) file_info, name, path, size, date - keeping (result)

Dates in fluent language

Search for a date in a text.

This is a very useful pattern to find Nth occurency of a data in this format dd/mm/yyyy but can be abstracted for other situations

extracts dates from text; Valid date format: dd-MMM-yyyy

For Dates formatted YYYY-MM-DD separated by Dot (.) Dash(-) or Slash(/) like (2021-04-08) with Zeros for single digit Month and Day.

For Dates formatted YYYY-M-D separated by Dot (.) Dash(-) or Slash(/) like (2021-9-2) without leading Zeros for single digit Month and Day.

For Dates formatted DD-MM-YYYY separated by Dot (.) Dash(-) or Slash(/) like (28–02-2021) with leading Zeros for single digit Month and Day.