May 6th, 2013, 06:04 PM
Join Date: May 2013
Time spent in forums: 42 m 38 sec
Reputation Power: 0
Other - Missing :00 in date-time field of csv file
The files that I download have a date and time field that mostly looks like this:
However, wherever the seconds are zero (00), it does not include the :00, so it looks like this:
instead of like this:
I need to apply a regex to the files, to modify all records that are missing :00 so that they appear with :00.
Here are 3 records from the file, the second one has the problem.
Can someone provide a regex that will make this modification in place throughout the file? Thanks. (Note: This is not a school homework assignment.)