Can successfully SPLIT .png or .jpeg from image file name in EnumList

I found the test app “Images in Buttons” in one of the topics. It uses images as buttons in an EnumList. For my purposes it will allow users that can’t read, to make their choice based on the image rather than text. However, for users that can read, I do want a text output below that confirms their image based choice. (See screenshot)

In order to make it look more clean, I am trying to remove the .png or .jpeg from the image file name. But I am failing to do so for an EnumList. The current expression (for the column called “Choice”) reads:

TEXT([Choice])

It shows all choices made but with the .png ending.

Applying this expression:

INDEX( SPLIT([Choice], “.”), 1)

…takes care of removing the .png or .jpeg, but it leaves me with only one result, even when I pick multiple choices (as is possible in EnumList).

Could someone please help me with the expression, so that it would for the example in the screenshot, output: “Check, Lightbulb”?

Thank you!

Solved Solved
0 4 554
1 ACCEPTED SOLUTION

You are welcome.

Please try

SUBSTITUTE(SUBSTITUTE(TEXT([Choice]), “.PNG”,"") , “.JPEG”,"")

I am sorry that I should have shared help article on SUBSTITUTE()

AppSheet has rich documentation at Customer Support - AppSheet and please search by keywords.

View solution in original post

4 REPLIES 4
Top Labels in this Space