https://community.cloudera.com/t5/Support-Questions/Nifi-Substring-index-out-of-bounds-error/m-p/236282#M198095 <A rel="user" href="https://community.cloudera.com/users/97732/jacobhansraj.html" nodeid="97732">@Jacob Paul</A><P>I believe your flowfiles having <STRONG><U>source-date1</U></STRONG> attribute with value <STRONG>20181119112100.</STRONG></P><P>Then change your <A href="https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html#substring" target="_blank">update attribute</A> property values as</P><P><STRONG>source-date</STRONG> as</P><PRE>${source-date1:substring(0,8)}</PRE><P><STRONG>source-time</STRONG> as</P><PRE>${source-date1:substring(8,13)}</PRE><P>Then update attribute adds these flowfile attributes for all outgoing flowfiles from UpdateAttribute processor.</P><P>In addition you can also perform same kind of operation without extracting as attributes using <A href="https://community.hortonworks.com/articles/121794/running-sql-on-flowfiles-using-queryrecord-process.html" target="_blank">QueryRecord processo</A>r.</P><P>Configure/Enable Record <STRONG>Reader/Writer controller services</STRONG> and use <STRONG>apache-calcite's</STRONG> <STRONG>Substring </STRONG>function to create source-date,source-time columns in the flowfile.</P> Tue, 20 Nov 2018 05:27:38 GMT Shu_ashu 2018-11-20T05:27:38Z