title: in Nifi and with QueryRecord processor can we add a new column that is a regex of another column
body: <p>in Nifi and with QueryRecord processor can we add a new column that is a regex of another column in a query?</p>
  <p>Like : <code>SELECT info, SUBSTRING(info, &quot;([^\s]+)&quot;) as f_name FROM FLOWFILE</code></p>
  <p>I don't want to split my flowfile, ExtractText, UpdateAttributes, then attributesToJson and MergeContent. seems like along loop and it will take time if we talking about 400MB per FlowFile with 100k+ rows each</p>
  <p>input:</p>
  <pre><code>{&quot;info&quot;:&quot;Rachel: %Robert-100-400-4444-Mrs&quot;}
  {&quot;info&quot;:&quot;: %Martin-200-500-5555-Mr&quot;}
  {&quot;info&quot;:&quot;%Holand-300-600-6666-Mr&quot;}
  </code></pre>
  <p>desired output:</p>
  <pre><code>{&quot;info&quot;:&quot;Rachel: %Robert-100-400-4444-Mrs&quot;, &quot;f_name&quot;:&quot;Rachel&quot;,&quot;l_name&quot;:&quot;Robert&quot;,&quot;area_code&quot;:100,&quot;last_four_digit&quot;:4444,&quot;title&quot;:&quot;Mrs&quot;}
  {&quot;info&quot;:&quot;: %Martin-200-500-5555-Mr&quot;, &quot;f_name&quot;:&quot;&quot;,&quot;l_name&quot;:&quot;Martin&quot;,&quot;area_code&quot;:200,&quot;last_four_digit&quot;:5555,&quot;title&quot;:&quot;Mr&quot;}
  {&quot;info&quot;:&quot;%Holand-300-600-6666-Mr&quot;, &quot;f_name&quot;:&quot;&quot;,&quot;l_name&quot;:&quot;Holand&quot;,&quot;area_code&quot;:300,&quot;last_four_digit&quot;:6666,&quot;title&quot;:&quot;Mr&quot;}
  </code></pre>