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.
Extract ID and project and create custom attributes like projectID=ID and modelProject=project.
Did you already think about to transform your csv to json and then rebuild it with JOLT?