<?xml version="1.0" encoding="windows-1252"?>
<node id="995581" title="Re: Epoch time conversion in CSV" created="2012-09-25 11:50:35" updated="2012-09-25 11:50:35">
<type id="11">
note</type>
<author id="171588">
BrowserUk</author>
<data>
<field name="doctext">
&lt;blockquote&gt;&lt;i&gt;&lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;Ostensibly, all you'd need is:&lt;code&gt;
perl -F, -nle"$_ = localtime( $_ ) for @F[0,1]; print join ',', @F" &lt; infile &gt; outfile
&lt;/code&gt;

&lt;p&gt;See [http://perldoc.perl.org/perlrun.html|perlrun] for the command line switches and [http://perldoc.perl.org/functions/localtime.html|localtime()] for the function that does the work.

&lt;div class="pmsig"&gt;&lt;div class="pmsig-171588"&gt;
&lt;hr /&gt;
&lt;font size=1 &gt;
&lt;div&gt;With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'&lt;/div&gt;
&lt;div&gt;Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.&lt;/div&gt;
&lt;div&gt;"Science is about questioning the status quo. Questioning authority". &lt;/div&gt;
&lt;div&gt;In the absence of evidence, opinion is indistinguishable from prejudice.
&lt;p align=right&gt; [http://thebottomline.cpaaustralia.com.au/|RIP Neil Armstrong]&lt;/p&gt;&lt;/div&gt;
&lt;/font&gt;

&lt;/div&gt;&lt;/div&gt; network sites: </field>
<field name="root_node">
995574</field>
<field name="parent_node">
995574</field>
</data>
</node>
