Sorry if I'm overlooking the obvious, but is ...

(Brady Lovell) #1

Sorry if I’m overlooking the obvious, but is there something in AppSheet that will do the same thing as REGEXEXTRACT in gSheets?

(Aleksi Alkio) #2

You can do so many different things with the Regexextract and it would help us if you can describe your case more deeply. We don’t have the same kind of expression, but you can construct your own when you know the request.

(Brady Lovell) #3

@Aleksi_Alkio One of our customers we ship melons to is Walmart. Walmart has Distribution Centers all over the country. So in my [Customer] column, I have values like Walmart Shelbyville and Walmart Henderson and Walmart Arcadia. In my gSheet, I use the REGEXEXTRACT in an IF statement, to show a .png thumbnail file for each of my orders within the app. Like this…

IF(ISTEXT(REGEXEXTRACT(P2, “Walmart”)), “Graphics/Thumbnails/thumbWalmart2.png”,

Was just curious if I can set filters in AppSheet the same way?

(Aleksi Alkio) #4

How about… IFS(CONTAINS([Customer],“Walmart”),thumbWalmart2.png)