How to extract particular column data and assign to custom attributes using Nifi?

[#1]

Hi,

I have a scenario where I will be reading csv file, from that i have extract column value(s) and assign to custom attribute(s). From custom attributes I have to form a json file.

I have gone through the extractText processor we need to pass regular expression to get the text,  not quite understanding with that, is there any better and easy way to get above requirement?

sample csv file.

ID	Description	Status	project
8075	John	Done	xyz100

Extract ID and project and create custom attributes like projectID=ID and modelProject=project.

Thanks

--Murali

[#2]

Did you already think about to transform your csv to json and then rebuild it with JOLT?