Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing - moving to new a line

sriniprad08
11 - Bolide

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

 

sriniprad08_0-1678726956788.png

 

13 REPLIES 13
sriniprad08
11 - Bolide

Hi Team,

 

Can you please let me know how can we move or Is it possible to split if there are three values separated by |?

 

Thanks

 

sriniprad08_0-1678779857095.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

 

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

Sri

binuacs
21 - Polaris

@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 

 

binuacs_0-1678793134143.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

 

Thank you so much. Appreciate this.

 

Cheers,

Sri

Labels
Top Solution Authors