Write header of csv files in Uppercase and add string to every value in Apache Nifi-CodePudding

I have CSV files like this one below. I would like to change the first line to be in uppercase (the special characters should remain the same):

id;name;description_jobs;name22
5;James;student;James22
7;John;police-officer;John12

The result should look like this:

ID;NAME;DESCRIPTION_JOBS;NAME22
5;James;student;James22
7;John;police-officer;John12

CodePudding user response：

You can use .

Pay attention to the "Search Value" which actually takes first line and to "Replacement Value" which makes it upper case. You will get this output:

ID;NAME;DESCRIPTION_JOBS;NAME22
5;James;student;James22
7;John;police-officer;John12

CodePudding user response：

I would use the ExecuteStreamCommand processor to run a python script. It would read the flowfile from STDIN then write to STDOUT with the first line capitalized.