<?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>question Groovy Script in ExecuteScript Processor To Format Date value from flow file in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Groovy-Script-in-ExecuteScript-Processor-To-Format-Date/m-p/230207#M192057</link>
    <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="40894-nifihelp.png" style="width: 501px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/15040iA09570D21259A685/image-size/medium?v=v2&amp;amp;px=400" role="button" title="40894-nifihelp.png" alt="40894-nifihelp.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;I have json flow file with values in Mon Oct 09 23:38:55 IST 2017 format.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="40895-nifihelp.png" style="width: 501px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/15041i698EB702AC9FB90C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="40895-nifihelp.png" alt="40895-nifihelp.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I'm trying to change format to '2017-09-11 19:56:13'.&lt;/P&gt;&lt;P&gt;to accomplish this I selected ExecuteScript Processor below is my groovy script which is not working.&lt;/P&gt;&lt;P&gt;Please give me any suggestion on this.&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Rakesh.&lt;/P&gt;&lt;PRE&gt;import org.apache.commons.io.IOUtils
import java.nio.charset.* 
def flowFile = session.get() 
if(!flowFile) return 
flowFile = session.write(flowFile, {inputStream, outputStream -&amp;gt; 
     def jsonSlurper = new JsonSlurper() 
     def object = jsonSlurper.parseText(flowFile) 
     assert object instanceof Map 
     object.each { key,value -&amp;gt; 
      String Regex = "([a-zA-Z]{3} [a-zA-Z]{3} \d{2} \d{2}\:\d{2}\:\d{2} [a-zA-Z]{3} \d{4})" 
      if($value ==~ Regex){ 
              $value = toDate("EEE MMM dd HH:mm:ss z yyyy"):toNumber():format("yyyy-MM-dd HH:mm:ss.S")
            } 
         }
      outputStream.write(object) 
   } as StreamCallback) 
flowFile = session.putAttribute(flowFile)
session.transfer(flowFile, REL_SUCCESS)
&lt;/PRE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="40893-nifiredhelp.png" style="width: 539px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/15042i0E8BB7C780E501BA/image-size/medium?v=v2&amp;amp;px=400" role="button" title="40893-nifiredhelp.png" alt="40893-nifiredhelp.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Sun, 18 Aug 2019 00:49:46 GMT</pubDate>
    <dc:creator>rakesh999_alla</dc:creator>
    <dc:date>2019-08-18T00:49:46Z</dc:date>
  </channel>
</rss>

