<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Convert timestamps in transforms.conf? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/Convert-timestamps-in-transforms-conf/m-p/39965#M7426</link>
    <description>&lt;P&gt;This feature does not exist as of Splunk 4.3.  Today, your best option is a macro that implements your series of &lt;CODE&gt;eval&lt;/CODE&gt; operations.&lt;/P&gt;

&lt;P&gt;There are rumours that the next major release of Splunk will support a feature quite similar to this.  But, of course, the exact feature content of the next release is always subject to change.  I would recommend keeping an eye out.&lt;/P&gt;

&lt;P&gt;I think one thing to point out is that you don't necessarily want this done at &lt;STRONG&gt;index&lt;/STRONG&gt; time, but rather at search time.  The search-time late binding of field names to values is one of Splunk's strengths.&lt;/P&gt;</description>
    <pubDate>Tue, 21 Aug 2012 00:24:31 GMT</pubDate>
    <dc:creator>dwaddle</dc:creator>
    <dc:date>2012-08-21T00:24:31Z</dc:date>
    <item>
      <title>Convert timestamps in transforms.conf?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/Convert-timestamps-in-transforms-conf/m-p/39964#M7425</link>
      <description>&lt;P&gt;I'm new to this wonderful app, so pardon my inexperience if this is easy...I have a very long search string, but I'd like to have these values created automatically on index. How could I convert this set of converts and calculations into a transform?&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;source="/sge/default/default/common/accounting" 
| eval "Wait Time"=start_time-submit_time 
| eval "Run Time"=end_time-start_time 
| eval "Submit Time"=strftime(submit_time,"%Y %b %d %H:%M:%S") 
| eval "Start Time"=strftime(start_time,"%Y %b %d %H:%M:%S") 
| eval "End Time"=strftime(end_time,"%Y %b %d %H:%M:%S") 
| table uid job_name project qname "Submit Time" wait_time "Start Time" "End Time" run_time failed
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;I tried doing it this way to no avail:&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;[accttimeconvert]
eval "Wait Time"=start_time-submit_time
eval "Run Time"=end_time-start_time
eval "Submit Time"=strftime(submit_time, "%Y/%m/%d %H:%M:%S")
eval "Start Time"=strftime(start_time, "%Y/%m/%d %H:%M:%S")
eval "End Time"=strftime(end_time, "%Y/%m/%d %H:%M:%S")
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Mon, 20 Aug 2012 23:35:15 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/Convert-timestamps-in-transforms-conf/m-p/39964#M7425</guid>
      <dc:creator>holtb</dc:creator>
      <dc:date>2012-08-20T23:35:15Z</dc:date>
    </item>
    <item>
      <title>Re: Convert timestamps in transforms.conf?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/Convert-timestamps-in-transforms-conf/m-p/39965#M7426</link>
      <description>&lt;P&gt;This feature does not exist as of Splunk 4.3.  Today, your best option is a macro that implements your series of &lt;CODE&gt;eval&lt;/CODE&gt; operations.&lt;/P&gt;

&lt;P&gt;There are rumours that the next major release of Splunk will support a feature quite similar to this.  But, of course, the exact feature content of the next release is always subject to change.  I would recommend keeping an eye out.&lt;/P&gt;

&lt;P&gt;I think one thing to point out is that you don't necessarily want this done at &lt;STRONG&gt;index&lt;/STRONG&gt; time, but rather at search time.  The search-time late binding of field names to values is one of Splunk's strengths.&lt;/P&gt;</description>
      <pubDate>Tue, 21 Aug 2012 00:24:31 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/Convert-timestamps-in-transforms-conf/m-p/39965#M7426</guid>
      <dc:creator>dwaddle</dc:creator>
      <dc:date>2012-08-21T00:24:31Z</dc:date>
    </item>
  </channel>
</rss>

