Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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