Ask Your Question

Filter text (email) before @

asked 2016-06-17 17:45:48 +0200

MatthijsG gravatar image

updated 2020-07-10 21:49:24 +0200

Alex Kemp gravatar image

I've to comparise 2 columns of email-addresses with different domains (the top-level, like and

have the same text before the @.

should give an error. How can i filter only the text before the @, when the length is different. =left isn't working on this.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-17 23:28:52 +0200

m.a.riosv gravatar image

Something like


extract up to character before the first @ in the email address.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-17 17:45:48 +0200

Seen: 383 times

Last updated: Jun 17 '16