I need help with a text expression.
I have a cell with a text string that looks like this:
JT|MK|JR|RA|LM|UO
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.
You can convert it to a list like SPLIT(โJT|MK|JR|RA|LM|UOโ,"|"). See if it helps.
@Aleksi_Alkio how do I tell it to return just the 2nd thing in the list once it converts to a list
Use the INDEX() function
Thanks! Thatโs what I was missing!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |