I need help with a text expression.
I have a cell with a text string that looks like this:
In a separate form, the user will select one of the text strings between the |.
I am using the find function and can easily pinpoint which position the selection starts at, but then I want to tell appsheet to return that character plus the 2 after it in a virtual column for all rows.
How do I do this?
Looking through the text expression, I’m thinking some combination of find, left, or right, would work, but I can’t get the syntax right.