Display Pipe Separated Values

[rwksys]

I have a pipe separated set of values that are essentially tags or attributes of the row. Is there a good way to:

1. Display them so they appear as individual items and not pipe separated

2. Have them actually work as tags where, selecting one would behave as a link to other rows that contain that tag (text).

Example value:

Dog Friendly|For Sale: Cans|For Sale: Clothing|Lancaster|Outdoor Seating|South of Charlotte

I was playing with enum list as a possible solution, but it appears these may be limited to comma separated values.

[Steve · Accepted solution]

rwksys:

Display them so they appear as individual items and not pipe separated

Try:

SUBSTITUTE([Item_List], "|", "
")

Note that the expression itself is two lines . That’s critical!

Note, too, that the formatted lines must be in a LongText column. A Text column will collapse multiple lines into one.