Breaking Header into lines

[ferha_jafri]

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.

[Sebastiaandb]

Hi @ferha_jafri ,

Here you go:

let me know if this is what you're looking for :-).

Greetings,

Seb

[ferha_jafri]

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.

[PhilipMannering]

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.

[ferha_jafri]

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