Alteryx Breakpoints

[berty]

Hi, 

I'm trying to figure out how to split this data in the same cell - 543<br /> 3573<br /> skm

so it shows in the cell as:

543

3573

skm

any suggestions?

[rkapoor]

@berty have a look at the attached workflow.

Your delimiter is the <br /> so we can use the Text to Columns to split by rows or columns. In your case, splitting to rows will work.

We are then filtering only the data you need (non empty value).

[berty]

I don't need it split to rows, i need it split to new line in cell like so:

[rkapoor]

@berty I have amended your workflow to add the Summarize. This allows us to Concatenate the data with a newline (\n) delimiter.

[atcodedog05]

Hi @berty 

You can use a formula something like this

Replace([Field1], "<br /> ", "
")

where you are replacing <br /> with line break

Workflow

 Hope this helps 🙂