AnsweredAssumed Answered

Filter text for numbers and letters only

Question asked by MacDevGuy on Jun 15, 2018
Latest reply on Jun 20, 2018 by k-meson

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?