Hi, I have made some progress and specifically modified the regex in
ExtractText, as follows:

(.*?);(.*?);(\d+.*)

The same value is used as SearchValue in my ReplaceText and the Replacement
Value is as before = 

{ 
 "testField" : "${dsv.1}" 
}

This time, I am outputting the right value, but I am capturing the headers
too, as follows:

"HeadingA";"HeadingB";"HeadingC";"HeadingD";"HeadingE" 
 { 
 "testField" : "4787" 
} 

I have tried to use UpdateAttribute just before the ReplaceText, but the
headers are still in the output format. 

What is the best approach for removing the first line from my flowfile so
that only the Json format will be generated? Alternative, how can I modify
the SearchValue to skip the first line? 

Thanks and looking forward to sharing this with the community!



--
View this message in context: 
http://apache-nifi-developer-list.39713.n7.nabble.com/Using-the-template-cvs-to-json-to-convert-dsv-files-into-json-format-a-few-questions-tp9738p9992.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.

Reply via email to