in reply to Categorize rows on the basis of unix time

It is not hard to extract fields like hours or days from a unix epoch time. The function you need is gmtime. If you call it in an array context you get back the fields.

From there it is a simple matter to write a script that reads your input file line by line, parses the unix time, and then writes out a new file with the time fields you want and the remaining fields unmodified.

  • Comment on Re: Categorize rows on the basis of unix time