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.)
Can you write an expression that matches those lines?
Text editor solution:
I used EditPadLite, with the search/replace function set to Regex.
in the search box:
in the replace box:
Then I did a 'replace all'.
In LibreOffice Calc (after loading the csv file)
Menu>Edit>Find and Replace
Click "More Options" button, check Regular Expressions
In find box:
In replace box:
Click 'Replace all'