Auto Field Validation to Strip out trailing punctuation
I need to remove trailing punctuation on a field.
If I have Company, LLC that is okay but Company, LLC., is not okay, I would need to remove the ., at the end of the field.
Since there are some places where ., are valid I cannot use Filter. What else can I do?