AnsweredAssumed Answered

how would you add the @ sign to a filter function

Question asked by gethappy@happypc.com on Sep 23, 2016
Latest reply on Sep 23, 2016 by philmodjunk

I'm trying to use the FILTER function on an email address field but it seems to be ignoring the @ (at sign).  is there a trick I'm missing?

 

When i try ...

 

Filter ( emailaddress ; "@.-_abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234156789 " ) 

 

it strips the @ sign from the field ... which I don't want it to obviously.

 

I tried a backslash before the @ sign, didn't help.

Outcomes