I have an EnumList and in a Detail View I don’t want it to look like
Selection1 , Selection2 , Selection3
but with newlines like
Selection1
Selection2
Selection3
For that I use this Expression in a VC. This works fine and I can use the VC in the Detail View.
SUBSTITUTE([EnumList], " , ", "
")
But: I have to use a different Item Separator. Instead of " , " I want to use something more less used, like " § ". So I change the Item Separator to " § " and my expression to
SUBSTITUTE([EnumList], " § ", "
")
But the result in the VC will be
Selection1 , Selection2 , Selection3
It seems that the item separator will be ignored.
In my sheet the EnumList will be stored with " § " as the separator.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |