https://community.cloudera.com/t5/Support-Questions/Can-NiFi-extract-rows-of-data-from-csv-files-etc/m-p/166036#M128388 <P><A rel="user" href="https://community.cloudera.com/users/14005/ryoung.html" nodeid="14005">@Roger Young</A> since your csv seems to be of fixed columns, you can use an combination of Replace and Extract text. </P><P>You can use one the example template here which converts csv to json, the first step is what you need.</P><P><A href="https://cwiki.apache.org/confluence/download/attachments/57904847/CsvToJSON.xml?version=1&amp;modificationDate=1442927496000&amp;api=v2" target="_blank">https://cwiki.apache.org/confluence/download/attachments/57904847/CsvToJSON.xml?version=1&amp;modificationDate=1442927496000&amp;api=v2</A></P><P><A href="https://cwiki.apache.org/confluence/display/NIFI/Example+Dataflow+Templates" target="_blank">https://cwiki.apache.org/confluence/display/NIFI/Example+Dataflow+Templates</A></P> Wed, 21 Dec 2016 19:25:53 GMT nyakkanti 2016-12-21T19:25:53Z