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.