“The filenames are clearly timestamps. i.e.
170901_1554.mp3 would be
Sept 1, 2017 3:54PM”
How did you convert that?! I’m so excited. I need to save and print some text message conversations. I’ve saved the conversations, which are .VZM files. I change the extension to .TXT or .DOC, and I get a big mess on the screen, which I can go through and “clean up”, via search-and-replace, adding paragraphs, etc. BUT the dates and times aren’t there except in this numerical format.
I think I could save the files as .CSV, and format the cells/columns with this info. I would just need to know the format to use.
|
“The filenames are clearly timestamps. i.e. How did you convert that?! I’m so excited. I need to save and print some text message conversations. I’ve saved the conversations, which are .VZM files. I change the extension to .TXT or .DOC, and I get a big mess on the screen, which I can go through and “clean up”, via search-and-replace, adding paragraphs, etc. BUT the dates and times aren’t there except in this numerical format. I think I could save the files as .CSV, and format the cells/columns with this info. I would just need to know the format to use. |
The first two digits are the year, as in 2017. The next two digits are the month and the last of the first set of digits is the date. Following the underscore is the time based on a 24-hour clock. |
2019 - Start with the year. The reason for this becomes clear later, when you try to sort your files. They used a two-digit year. Four-digit is better, if you might be using dates from more than one century.
04 - Next is the month.
07 - Day
0857 - military time.
8:57 AM on April 7, 2019 becomes 201904070857. You can insert spaces and punctuation marks to make it more visually appealing. If you need to be more precise, you can add two digits to the end for seconds.