Hello All

I've searched but not found an answer so apologies if this is old territory!

I need to parse email addresses in FMP7 giving me just the domain, i.e.

= thisdomain.co.uk

I thought I found the answer using a substitue command to replace the @ symbol with a space within a rightwords function. This is fine until you get a domain with a hyphen in the middle "-", where you only get the second half of the domain.

Is there a better way??

Thanks

Matt

Try:

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

That's great - worked straight away.

Must improve my function knowledge!