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

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

0 3 333
3 REPLIES 3

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.

@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?

How aboutโ€ฆ IFS(CONTAINS([Customer],โ€œWalmartโ€),thumbWalmart2.png)

Top Labels in this Space