Solved: Remove All Numbers - Page 2

YGY · 09-01-2020 12:51 AM

Hoping someone can help me. I’ trying to remove all numbers and “-” from a text field:

So from this:
5-A,4-C,3-R

To This:
A,C,R

Thanks.

Suvrutt_Gurjar

Assuming your text string pattern remains identical as you confirmed , with AppSheet expressions, you could try

SUBSTITUTE(EXTRACTMENTIONS(SUBSTITUTE(“5-A,4-C,3-R”,"-","@")),"@","")

Will give following result ( with space before and after commas)

A , C , R

Alternatively, a still longish expression
SUBSTITUTE(SUBSTITUTE(EXTRACTMENTIONS(SUBSTITUTE(“2-A,3-B,5-R”,"-","@")),"@","")," , “,”,")

Will give following result ( without space before and after commas as your given example shows)

A,C,R

Edit: Minor edits in description.