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.

 

NameFirst&"_"&NameLast&"@"&"Company.com"

 

 

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?

Outcomes