Regular Expressions

[Joseph_Seddik]

Hello,

Powerful text processing capability would be an enormous addition to AppSheet. I would like to raise a request for Regular Expression support in AppSheet please.

Proposed commands: 

1. REGEX(pattern, string)

where: 

• pattern: regular expression pattern that can support an optional capturing group. 
• string: text in which to search for pattern. 

Return value - LIST of TEXT values:

• A list of text segments matching pattern in string, or in case of use of a capturing group, then return a list of text segments matching the capturing group in string.
• Empty list when no match is found either for pattern, or capturing group. 

2. REGCOUNT(pattern, string)

where: 

• pattern: regular expression pattern that can support an optional capturing group. 
• string: text in which to search for pattern.

Return value - INTEGER:

• Number of occurrences of matching pattern in string. 
• 0, in case there are no matches.  

3 .REGSUB(pattern, string, replacement)

where: 

• pattern: regular expression pattern that can support an optional capturing group. 
• string: text in which to search for pattern.
• replacement: alternative text to replace the matching segment.

Return value - LIST of TEXT values:

• List of text segments matching pattern in string, or
• Empty list in case there is no match.

Thanks much in advance.   

[squatch4014]

Well documented post.  I would highly use this feature if it was available.

[Joseph_Seddik]

Thank you. 

I have modified the proposed Return Value to be a LIST instead of TEXT. 

I hope this request gets considered.