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.
@Fabian
Is there a special reason for trying to use a special character for the list?
" , " (space, comma, space) is not commonly used.
@Steve You are right. But it may happen.
The EnumList has a Table as a source. A user could create an entry in that table like:
โThatโs an example , just to test itโ
This entry would be splited in two.
This is what I want to avoid. Thatโs why I want to use a special character that a user will not use.
You could use Value_If to prohibit entries that contain " , "โฆ
Youโre right. That would also be a workaround.
Hi Steve, I m new to appsheetโฆ How to prohibit the entries that contain " , " in enum list
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |