arvind

arvind

  • NA
  • 0
  • 3.6k

What is the regex for date and date with time

Jul 13 2015 8:21 AM
I have a excel file in that there is a date column, in some of the row I have date with time and some of the row having date without time there is also some other columns after date column to write regex. I have used this : (?<DEALDATE>(\d+/\d+/\d+)\s(\d+:\d+:\d+)) but this is not able to match date without time.
23/03/2015 16:02:34 employeename1
23/03/2015 employeename2

Answers (2)