Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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