Breaking Header into lines

Question

Hello Experts,

I have a scenario in which I want to break the hears into different line eg. for Header as Input Ferha Sharma AND Jafri AND Mumbai will be transfromed like

Ferha Sharma

Jafri

Mumbai

So the line break happend after AND in headers.

Thanks in advance.

ferha_jafri · Answer

It is not working when I am writing the output to render tool and for my requirement I have to use render tool.

philipmannering · Answer

Hi @ferha_jafri

Perhaps something like this in the dynamic rename tool,

replace([_CurrentField_], ' AND ', '
')

It's more obvious that new lines are being imputed when written out to a csv or excel file.

New lines in headers.yxmd

ferha_jafri · Answer

Thanks for your reply, but they are the headers and I am looking for break after AND and new line get incerted within the same cell. In your case it is getting splitted into 3 different lines.