<?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 Using ExtractText for filtering rows with regular expression does not work in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Using-ExtractText-for-filtering-rows-with-regular-expression/m-p/312281#M225073</link>
    <description>&lt;P&gt;I have create a data pipeline that fetches an excel file and copies it into a table in a SQL Server. I have used ExtractText processor to filter rows by using a regular expression, as from the post at &lt;A href="https://community.cloudera.com/t5/Community-Articles/NiFi-ETL-Removing-columns-filtering-rows-changing-field/ta-p/248149" target="_blank"&gt;https://community.cloudera.com/t5/Community-Articles/NiFi-ETL-Removing-columns-filtering-rows-changing-field/ta-p/248149&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have validated the used regular expression at &lt;A href="https://www.freeformatter.com/java-regex-tester.html#ad-output" target="_blank"&gt;https://www.freeformatter.com/java-regex-tester.html#ad-output&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, the filter produces no match and no data is written in the SQL Server.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;By omitting the filter, the flow works fine so the problem is clearly in the ExtractText processor.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have searched for possible hints in this and other forums with no success. Any idea what might be wrong?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Below is my complete configuration, the used source data and the configured SQL table.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks a lot in advance!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Flow:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1_flow.png" style="width: 954px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30551i2C73C6A2128C6046/image-size/large?v=v2&amp;amp;px=999" role="button" title="1_flow.png" alt="1_flow.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;GetFile processor:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2_get_file.png" style="width: 795px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30552iA696E490EB420669/image-size/large?v=v2&amp;amp;px=999" role="button" title="2_get_file.png" alt="2_get_file.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;ConvertExcelToCSVProcessor:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3_convert_to_CSV.png" style="width: 790px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30554iD97A80E0A70CE028/image-size/large?v=v2&amp;amp;px=999" role="button" title="3_convert_to_CSV.png" alt="3_convert_to_CSV.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SplitText processor:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4_split_rows.png" style="width: 794px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30555i5C0AB268A9A2777B/image-size/large?v=v2&amp;amp;px=999" role="button" title="4_split_rows.png" alt="4_split_rows.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;ExtractText processor:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5_filter_rows.png" style="width: 796px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30556i9D955199194565AE/image-size/large?v=v2&amp;amp;px=999" role="button" title="5_filter_rows.png" alt="5_filter_rows.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;PutDatabaseRecord processor:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="6_put_DB_record.png" style="width: 790px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30557i9383EA3B8960A70A/image-size/large?v=v2&amp;amp;px=999" role="button" title="6_put_DB_record.png" alt="6_put_DB_record.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;DBCPConnectionPool controller service:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="7_DB_Connector.png" style="width: 792px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30558i8F5F6B59296D0D12/image-size/large?v=v2&amp;amp;px=999" role="button" title="7_DB_Connector.png" alt="7_DB_Connector.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;CSVReader controller service:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8_CSV_reader.png" style="width: 793px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30559iA07920B922573303/image-size/large?v=v2&amp;amp;px=999" role="button" title="8_CSV_reader.png" alt="8_CSV_reader.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Source data&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="9_source_data.png" style="width: 999px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30560i798BF8F8E0E80E93/image-size/large?v=v2&amp;amp;px=999" role="button" title="9_source_data.png" alt="9_source_data.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Target table:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10_target_table.png" style="width: 514px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/30561iA71C73C20B502059/image-size/large?v=v2&amp;amp;px=999" role="button" title="10_target_table.png" alt="10_target_table.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 02 Mar 2021 08:07:15 GMT</pubDate>
    <dc:creator>BerniHacker</dc:creator>
    <dc:date>2021-03-02T08:07:15Z</dc:date>
  </channel>
</rss>

