I have a column that is an Enum type that displays images in my app. I am using an expression in another column similar to “Contains([Front Head Type],“blah”)” that performs some calculations based on the Enum selection.
The images are all stored in the drive folder and end in .jpg. No problems getting them to display however, the enum columns [Front Head Type] & [Rear Head Type] are referenced in the display name of other columns as well as in a workflow. I would like to get rid of the file type “.jpg” in the string. I’ve looked through the documentation and tried the following without any success.
In App: SUBSTITUTE([Front Head Type],".jpg","")
In Workflow: <<SUBSTITUTE([Front Head Type],".jpg","") >>
Error messages state “Parameter 1 of Substitute is used incorrectly”, any idea how i can modify the string to remove “.jpg” as is not relevant to anyone using the app or workflow but simply part of the file name used in the enum?