Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Epoch time conversion in CSV

by BrowserUk (Pope)
on Sep 25, 2012 at 15:50 UTC ( #995581=note: print w/replies, xml ) Need Help??

in reply to Epoch time conversion in CSV

Ostensibly, all you'd need is:

perl -F, -nle"$_ = localtime( $_ ) for @F[0,1]; print join ',', @F" < +infile > outfile

See perlrun for the command line switches and localtime() for the function that does the work.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.

RIP Neil Armstrong

network sites:

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://995581]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2018-02-23 04:58 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (300 votes). Check out past polls.