I've googled everywhere for this and everything I run across its super complicated. It should be relatively simple to do. The recommendations show to look at the "Example_With_CSV.xml" from here.
So given a flowfile thats a CSV.
2017-09-20 23:49:38.637,162929511757,$009389BF,36095,,,,,,,,,,"Failed to fit max attempts (1=>3), fit failing entirely (Fit Failure=True)"
$date = 2017-09-20 23:49:49:38.637
$id = 162929511757
$instanceid = 36095
$comment = "Failed, to fit max attempts (1=>3), fit failing, entirely (Fit Failure=True)"
$csv.date = ...
$csv.id = ...
$csv.instanceid = ...
$csv.comment = ..
Is there another easier option to do this besides RegEx? I can't stand to do anything with RegEx as how unreadable, and overly complicated they are. To me there should be a significantly easier way of doing this than with RegEx.
https://cwiki.apache.org/confluence/display/NIFI/Example+Dataflow+Templates but it doesn't have anything in there related to actually getting the columns of each value out.