In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Formatting

Sifiso
8 - Asteroid

Dear all

 

please help.

 

I want the logic that will put the text (paragraph) in point form in the same cell.

 

Something Like: If this delimiter “|” is picked up then start below.

 

example

ID

Summary

0001

The bolt was 2mm out of spec. | obsolete drawing was issued. | remove obsolete drawings from the system.

 

Required Output

ID

Summary

0001

- The bolt was 2mm out of spec.

- obsolete drawing was issued.

- remove obsolete drawings from the system.

3 REPLIES 3
flying008
15 - Aurora

Hi, @Sifiso 

 

 

flying008_1-1684997053740.png

 

录制_2023_05_25_14_48_48_213.gif

 

 

******

If can help you get your want, please mark it as s solution for more share.

Sifiso
8 - Asteroid

Hi  flying008

 

can you attach the workflow?

flying008
15 - Aurora

Hi, @Sifiso 

 

The Formula:

 

Replace(Replace('-' + [Summary], "|", "|-"), "|", "
")

 

Labels
Top Solution Authors