New Bug Encountered: EnumList Item separator

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.

0 6 949
6 REPLIES 6

@Fabian
Is there a special reason for trying to use a special character for the list?

Steve
Platinum 4
Platinum 4

" , " (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

3X_7_0_70ef65aee35cbe7ebda8e4577e0f67478745dc3d.png

Top Labels in this Space