Using Regex for specific filter: Exclude symbols
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.
|
|
[] |
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 icon 
Having used the expression ^((?![@/]).)*$ to filter the column, all lines that contained the symbols @ or / have now been excluded.
