In this example we want to exclude everything that contains@or/
To do this, we will use the following Regular Expression:
^((?![@/]).)*$
Breakdown of the Regex elements used
^
Beginning of the string
()
Capturing Group
(?!)
Negative look ahead. This specifies a group that cannot match after the main expression. (i.e. if it matches, then the result is discarded)
[]
Matches any character in the set
@/
Character
.
Matches any character except line breaks
*
Match 0 or more of the preceding token
$
End of the string
Practical case
We can now use the expression explained above to single out group members. The Filter By Regular Expression option will be used to exclude everything that contains@(for emails) or/(for users).
Click on the filter iconand selectFilter By Regular Expression.
Having used the expression^((?![@/]).)*$to filter the column, all lines that contained the symbols@or/have now been excluded.
JavaScript errors detected
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.