Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Split CSV between Multiple Records in Apache NIFI

avatar
New Contributor

I am trying to process a CSV file and convert it to a JSON in a specific format. My CSV file is as follows

START

PI,0010002,25,king,address,phone

PE,3.2,company1

PE,1.9,company2

STOP

START

PI,0010003,25,prince,address,phone

PE,3.2,company1

PE,1.9,company2

STOP

I want help in extracting records from START till STOP. I was able to do the JSON conversion.

1 ACCEPTED SOLUTION

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Community Manager

@Prajeesh10  Has your issue been resolved? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

 

Screen Shot 2019-08-06 at 1.54.47 PM.png


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
New Contributor

id, name, balance, join_date, notes
1, John, 48.23, 04/03/2007 "Our very
first customer!"
2, Jane, 1245.89, 08/22/2009,
3, Frank Franklin, "48481.29", 04/04/2016,

the logic may fail in the above case, if column contains multiple rows.