I need help with a text expression. I have a...

AppSheet AppSheet Q&A
1

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.

2

You can convert it to a list like SPLIT(“JT|MK|JR|RA|LM|UO”,“|”). See if it helps.

3

@Aleksi_Alkio how do I tell it to return just the 2nd thing in the list once it converts to a list

4

Use the INDEX() function

5

Thanks! That’s what I was missing!