Great! for example in Contact there is a custom field Contact_Primary_Street__c. The difficulty is that for street and saint we would like to standardize that the input is always St. Ex: 5721 Saint Martens Street would become 5721 St. Martens St.
Also would be useful for Account name. Ex: Saint Martens Hospital to become St. Martens Hospital; & to and, Med to Medical; etc.
The goal to standarize naming as much as possible.
try this trigger
All Answers
You can do thisby
1) workflow
2) before insert , before update trigger
If you can provide me some more info about your object name, field name and req , I can help you creating a workflow or trigger to solve your issue.
Great! for example in Contact there is a custom field Contact_Primary_Street__c. The difficulty is that for street and saint we would like to standardize that the input is always St. Ex: 5721 Saint Martens Street would become 5721 St. Martens St.
Also would be useful for Account name. Ex: Saint Martens Hospital to become St. Martens Hospital; & to and, Med to Medical; etc.
The goal to standarize naming as much as possible.
try this trigger
Works like a charm!
Gr8, Please mark this as Accepted solution , so that it can benifit others as well.