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
Hey @sriniprad08.
Please see the attached workflow.
One way:
@sriniprad08 maybe that's clearer:
@sriniprad08 another way of doing this, if you have multiple fields to be replaced with the new line then, the below workflow works
@sriniprad08 I can see you changed the \ to |, you can use the same workflow which I sent , only update the replace formula inside the Multi-Field tool
Hi @binu_acs ,
Thank you so much. Really appreciate this. Sorry can you explain what you referring to multiple filed pleaes?
Cheers,
Hi @BS_THE_ANALYST ,
Thank you so much. Really appreciate this.
Hi @acarter881 ,
Cheer
@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.
Can you please let me know how can we move or Is it possible to split if there are three values separated by |?
Thank you so much for helping out. Is it also possible to split into multiple new line if more than two | are present in the text please?
Cheers
Thank you so much. Appreciate this.
