Hello Friends, I have column header names as below. Looking for header names should be like under "Need". Current HeaderNeed2022_12___Sum_Credit_Amount2022-12 - Sum Credit Amount2022_12___Sum_Debit_Amount2022-12 - Sum Debit Amount2022_12___Sum_SLA_Amount2022-12 - Sum SLA Amount

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Dynamic Processing

Accepted answers

All comments

binu_acs

@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:

Dynamic Rename.yxmd

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?

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