AVS Forum banner

What's In A Name?

1138 Views 2 Replies 3 Participants Last post by  cbarber
Hey All, a New and another HD crash....YEAH!!!!

But since extract_rtv RULES, it isn't any big deal...but, I am curious, is there a way to determine the date a show was recorded by the file name? Like 1166569200.mpg...I lost all the show descriptions and such and all I have is the Numberd name and the cluster of course, any way of determining anything of value from those?

1 - 3 of 3 Posts
The numeric part of the filename is a unix time (number of seconds since the Epoch). If you're on a unix box (or mac os X), there are a number of command-line ways to convert it. Here's a quick one:

> tclsh

% clock format 1166569200

Tue Dec 19 18:00:00 EST 2006

On windows, I think there's an excel function you can use but can't recall it off hand.
FWIW, Unix keeps time in seconds from an epoch, Excel in days from a different epoch. So the conversion requires converting from seconds to days and adjusting for the difference in epochs and time zone.

If the Unix time is in cell A1, the Excel formula is


which takes the Unix epoch: DATE(1970,1,1)

and adds the Unix time converted to days: (A1/60/60/24)

and subtracts the offset between GMT and EST: TIME(5,0,0)
1 - 3 of 3 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.