Parsing - moving to new a line

[sriniprad08]

Hi Team,

Hope you are well. I need help.

Please find attached the input and required output

The | has to be replaced with a new line.

Please let me know

Thanks

Sri

[acarter881 · Accepted solution]

Hey @sriniprad08.

Please see the attached workflow.

[BS_THE_ANALYST · Accepted solution]

One way:

[BS_THE_ANALYST · Accepted solution]

@sriniprad08 maybe that's clearer:

[binuacs · Accepted solution]

@sriniprad08 another way of doing this, if you have multiple fields to be replaced with the new line then, the below workflow works

[sriniprad08]

Hi @binuacs ,

Thank you so much. Really appreciate this. Sorry can you explain what you referring to multiple filed pleaes?

Cheers,

Sri

[sriniprad08]

Hi @BS_THE_ANALYST ,

Thank you so much. Really appreciate this.

Cheers,

Sri

[sriniprad08]

Hi @acarter881 ,

Thank you so much. Really appreciate this.

Cheer

Sri

[binuacs]

@sriniprad08 I used the muti-field tool because if you have more fields to parse then multi-field is the best option instead of using a formula tool. Multi-Field tool can take all the fields at once and process according to the formula mentioned in it.

[sriniprad08]

 hi @binuacs ,

Great. thank you. Is it possible to split if there are three values separated by |?

Please let me know thanks,