Can I sort by domain name only

[Johnny777]

Hi all

Is it possible to sort records by email domain name on a set of contacts records.

The way I have thought to do it is to create a variable based on the email - strip out the part before the @ symbol - put it in another field and then sort by that field.

Has anyone got any alternatives and is there a function for taking off the first part of the email address

Thanks for reading all

[doughemi]

Sounds like a good way to me.

Calculated field DomainName = Right(EmailAddr; Length(EmailAddr - Position("@"; EmailAddr; 1; 1)))

[comment]

Right(EmailAddr; Length(EmailAddr - Position("@"; EmailAddr; 1; 1)))

That doesn't look right.

[doughemi]

That doesn't look right.

Boy, I'll say! Much better:

Right(EmailAddr; Length(EmailAddr)- Position( EmailAddr; "@";1; 1))

(tested this time!) :rolleyes:

[Johnny777]

Hi all

The last post worked a treat

Thanks very much all

John