Display Pipe Separated Values

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.

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.

2 Likes