NiFI: how can i change space to underscore with ReplaceText

[#1]

Hello

I need to change the name of the columns.

Ex: 'item Type' became 'Item_Type'

Region	Country	Item Type	Sales Channel	Order Priority	Order Date	Order ID	Ship Date	Units Sold	Unit Price	Unit Cost	Total Revenue	Total Cost	Total Profit
Sub-Saharan Africa	Chad	Office Supplies	Online	L	1/27/2011	292494523	02/12/2011	4484	651.21	524.96	2920025.64	2353920.64	566105.00
Europe	Latvia	Beverages	Online	C	12/28/2015	361825549	1/23/2016	1075	47.45	31.79	51008.75	34174.25	16834.50
Middle East and North Africa	Pakistan	Vegetables	Offline	C	1/13/2011	141515767	02/01/2011	6515	154.06	90.93	1003700.90	592408.95	411291.95
Sub-Saharan Africa	Democratic Republic of the Congo	Household	Online	C	09/11/2012	500364005	10/06/2012	7683	668.27	502.54	5134318.41	3861014.82	1273303.59
Europe	Czech Republic	Beverages	Online	C	10/27/2015	127481591	12/05/2015	3491	47.45	31.79	165647.95	110978.89	54669.06

i'm trying to use the processor ReplaceText

But this is the result

Region	Country	Item_Type	Sales_Channel	Order_Priority	Order_Date	Order_ID	Ship_Date	Units_Sold	Unit_Price	Unit_Cost	Total_Revenue	Total_Cost	Total_Profit__Sub-Saharan Africa	Chad	Office Supplies	Online	L	1/27/2011	292494523	02/12/2011	4484	651.21	524.96	2920025.64	2353920.64	566105.00
Europe	Latvia	Beverages	Online	C	12/28/2015	361825549	1/23/2016	1075	47.45	31.79	51008.75	34174.25	16834.50
Middle East and North Africa	Pakistan	Vegetables	Offline	C	1/13/2011	141515767	02/01/2011	6515	154.06	90.93	1003700.90	592408.95	411291.95
Sub-Saharan Africa	Democratic Republic of the Congo	Household	Online	C	09/11/2012	500364005	10/06/2012	7683	668.27	502.54	5134318.41	3861014.82	1273303.59
Europe	Czech Republic	Beverages	Online	C	10/27/2015	127481591	12/05/2015	3491	47.45	31.79	165647.95	110978.89	54669.06
Sub-Saharan Africa	South Africa	Beverages	Offline	H	07/10/2012	482292354	8/21/2012	9880	47.45	31.79	468806.00	314085.20	154720.80

Can someone help me please?

[#2]

Hi,

Try using the replace text processor in "Literal Replace" mode for the Replacement Strategy setting.  It's no obvious, but I have placed a single space in the Search Value setting.

Alternatively, you could explore using an Avro schema to achieve this, and this links in nicely with your other question too.  For example, given a flow file with the content (I'm using the GenerateFlowFile to create this):

Using this flow as a test:

I've created content in the GenerateFlowFile of:

with an attribute called avro.schema:

Note the highlighted "name" attribute which defines the name you need on the output, and the "aliases" array value which is the input name value.

For reference, here's the GenerateFlowFile configuration:

The ConvertRecord has the following CSVReader configured:

And using an otherwise normally configured CSVRecordSetWriter I get the following output:

Also note that I have also changed the case using this approach, in fact you can rename the column to whatever you need.

I found working with Avro schemas a bit of a steep learning curve, but definitely worth the time investment.  I mention this in particular as it compliments your other question about date formats very well.

Hope that helps