Chopping up email addresses

[Grunners]

Hiya all,

I had this brilliant idea to cut down on the spam in our office - it works but if I don't put an 'allow' list in to our firewall I get all the spam by default!

We have hundreds of trusted email addresses on a database. Thing is I don't want the whole email address - just the domain.

I.e. myname@mycompany.co.uk just needs to become mycompany.co.uk.

My question: How do I just get the characters after the @

Any answer can be code or sql based and many thanks in advance for any advice!

Thank God it's Friday...

 

[neileg]

Use instr to find the position of the @ and then use right to take everything to the right of the @. Like this, assuming email is the field with the full address

Right(,Len([email])-InStr([email],"@")) AS lastbit

 

[Grunners]

Thanks neileg!

It worked a treat. String manipulation actually scares me... I'll have to practice more... Hmmmmph

Best Regards
Grunners

 

[Mark Drayton]

Thanks neileg.

I wanted to get the first name from a full name string and you put me on the right path.

For example:

John Smith (Full Name str) wanted to just get the First name .... hey presto...

Left([Full Name str],InStr([Full Name Str]," "))

Ta

Mark