Reputation: 2107
In cases specific special characters could be added as follows:
=FILTER(D1:D, REGEXMATCH(D1:D, "^("®EXREPLACE(TEXTJOIN("|", 1, A:A),"([().])","\\$1")&")$")=FALSE)
But when wanting to analyze all of them, the best approach would be a negative match, fetching all the different values of A-Z
, a-z
, and 0-9
.
So, I tried to reproduce it with a direct addition that finds the values but when matching the values, it returns the number of matches to zero:
=FILTER(D1:D, REGEXMATCH(D1:D, "^("®EXREPLACE(TEXTJOIN("|", 1, A:A),"([^A-Za-z0-9])","\\$1")&")$")=FALSE)
What is the correct approach in this case?
Google Sheets data with expected result
Upvotes: 0
Views: 825