REGEX() expressions and an optional occurrence parameter for SUBSTITUTE()

@praveen @tony
Is it possible to have powerful expressions like:
REGEXMATCH() (returns a TRUE/FALSE)
REGEXEXTRACT() (returns TEXT)
REGEXREPLACE() (returns TEXT)

I’m aware that the EXTRACT() expression can perform alike but at the end this function returns a list and it’s a bit limited in nature.

Additionally we need an optional occurrence parameter for the SUBSTITUTE expression which can save us from creating nested SUBSTITUTE expressions where expressions can become cleaner.

SUBSTITUTE( text_to_search, search_for, replace_with, [occurrence_number] )

What do you think?

Yes, REGEX would be a huge upgrade for the current text-parsing abilities in AppSheet!

There are already 9 votes over on this request though:


I can definitely see this being useful. I agree the SUBSTITUTE() function is a bit limited.

I had a different idea for optional extra pairs of text_to_search, text_to_replace.

1 Like

I don’t vote for many feature requests, but I voted for this one!

The downside: supporting them.

2 Likes

That’s why Regex 101 is for @Steve. Regex is a very strong tool and a deep well yet, therefore if someone needs a solution, everyone need to make their hands dirty. We can only enlighten the path to the best of our knowledge here and we all are not magicians :hugs: Thanks for your support btw, highly appreciated.

2 Likes