Are these characters before or after the @ symbol or both? Are you using a Workflow step or Function or both?
Hyphens are allowed. My understanding apostrophes are not allowed after the @ symbol. Before the @ symbol are technically valid in more recent specs, but are often blocked by mail servers so Data Studio will flag as invalid. You can test if they return undeliverable here:
Let us know your results
Thanks Josh - I can see that the apostrophes are being flagged as invalid although our users are challenging these fails. I just wanted to understand your approach to this.
Could you elaborate on which type of email validation you are using?
If you are simply doing a format check, emails with hyphens should validate as true for the name and first part of the domain (i.e. [email protected]) whereas the last part of the domain should not contain them (i.e. [email protected]). Apostrophes are allowed in the name but not the domain (i.e. fred-blogg'[email protected] is valid, but [email protected]'mail.com is not).
We use an industry standard library to verify the format of emails, but the other check types are more involved and IIRC check the existence of the address to varying degrees.
To elaborate further, the email validate step behaves as above, but the email validate function is using a more basic regex to validate email addresses that works slightly differently. I will open a ticket to bring this into line with the step.