I am looking to do something like this avoid using multiple expressions; or is a lookup going to be my only option?
One Expression:
ReplaceAll(NAMELAST, "?", "")|ReplaceAll(NAMELAST, ".", "")|ReplaceAll(NAMELAST, "#", "")|ReplaceAll(NAMELAST, "@", "")|ReplaceAll(NAMELAST, "!", "")
Using just ReplaceAll(NAMELAST, ".", "") does remove periods from names, but I am unable to add anymore to it.
Something similar to what I am trying can be done in excel with something similar to this:
=IF(ISNUMBER(SEARCH(OR(".","?","#","@","!"), A1)),A1,"")
(Not even sure if that would work but I think it relays what I am trying to do.
