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 : (?(\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
Guest UserPosted Jul 13, 2015, 8:56 AM
Raja TPosted Jul 13, 2015, 1:13 PM
Please refer below URL.
http://regexlib.com/DisplayPatterns.aspx?cattabindex=4&categoryId=5
Thanks