Community

Thanks Guys! Sorry I was so late to get back. ben_josephs solution works for some, but I could not get Bob's to work for some reason. The date formats are all mixed, some are mm/dd/yy, others mm/dd/yyyy, or yy/mm/dd, yyyy/mm/dd, d-Jan-yy, etc. So it's going to be quite a bit of work to get it all to ...

Hello! I have an issue regarding a find & replace of mixed date formats in a csv file to a default mysql format. I've attempted to use something like the following regular expression (regexp) with no success. FIND: \([1-9]|0[1-9]|1[012]\)[- /.]\([0-9]|0[1-9]|[12][0-9]|3[01]\)[- /.]\((19|20)[0-9 ...