Skip to main content
Skip table of contents

Examples - excluding a symbol

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.
(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).

ex-using-regex-exclude-symbols


Click on the filter icon 
regex-Filt-Button3
 and select Filter By Regular Expression.

ex-using-regex-exclude-symbols-2


ex_using-regex-exclude-symbols-3


Having used the expression ^((?![@/]).)*$ to filter the column, all lines that contained the symbols @ or / have now been excluded.

ex_using-regex-exclude-symbols-4

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.