How to use replace

[ArijitRoy]

Hello Friends,

I have column header names as below. Looking for header names should be like under  "Need".

Current Header	Need
2022_12___Sum_Credit_Amount	2022-12 - Sum Credit Amount
2022_12___Sum_Debit_Amount	2022-12 - Sum Debit Amount
2022_12___Sum_SLA_Amount	2022-12 - Sum SLA Amount

[binuacs]

@ArijitRoy Use the ReplaceChar() function 

ReplaceChar([Current Header],’_’,’-‘)

[DavidSkaife]

Hi @ArijitRoy 

Here is a way of doing it without using the Replace function, but with Dynamic Rename tool so you don't have to write multiple Replace statements to cover all outcomes:

Define your headers in a Text Input tool like so:

Configure the Dynamic Rename tool like so:

[ArijitRoy]

Hi @DavidSkaife,

According to the example, I have shared the Year and Month as 2022_12, I have in continuation as 2023_01, 2023_02, 2023_03 & 2023_04. Is this tool work?

[DavidSkaife]

Hi @ArijitRoy 

As long as you put them in the same order they are in the original headers, the tool should work

[ArijitRoy]

Hi @DavidSkaife, 

It is not working. Below is the screenshot of the data I have.

[DavidSkaife]

Hi @ArijitRoy 

what output are you getting? Can you share your workflow at all?

[ArijitRoy]

Hi @DavidSkaife,

Attached an example of the tool with less data. Currently we have data till April. I want future months also get changed accordingly.

Current status	Looking for
2022_12___Sum_Credit_Amount	2022-12 - Sum Credit Amount
2022_12___Sum_Debit_Amount	2022-12 - Sum Debit Amount
2022_12___Sum_SLA_Amount	2022-12 - Sum SLA Amount
2023_01___Sum_Credit_Amount	2023-01 - Sum Credit Amount
2023_01___Sum_Debit_Amount	2023-01 - Sum Debit Amount
2023_01___Sum_SLA_Amount	2023-01 - Sum SLA Amount
2023_02___Sum_Credit_Amount	2023-02 - Sum Credit Amount
2023_02___Sum_Debit_Amount	2023-02 - Sum Debit Amount
2023_02___Sum_SLA_Amount	2023-02 - Sum SLA Amount
2023_03___Sum_Credit_Amount	2023-03 - Sum Credit Amount
2023_03___Sum_Debit_Amount	2023-03 - Sum Debit Amount
2023_03___Sum_SLA_Amount	2023-03 - Sum SLA Amount

[ArijitRoy]

Keep the first column header (Invoice Reference Number) as it is.

[DavidSkaife]

Hi @ArijitRoy 

I've attached your workflow with it working; i've done it slightly differently in that the mapping text input has the original and the replacement field names, that way it doesn't matter what order you have them in