I have a calculation in one of my database fields to create the email address from the first and last name following the standard the company uses. This is working great.
It returns what I want. A problem has cropped up though where some names have hyphens or diacritics which aren't used. So how to hand a name such as Tony D'Marco?
I want to strip the ' that occurs between the D and Marco. How can I do that?