function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Travis16Travis16 

Remove Special Characters from end of Formula

I have a workflow rule that updates the Opportunity name and for some of them they are ending in a special Characters IE. "." due to the Account name ending in Co. or Inc. 

Below is the formula and I need to write it to stop the ending of the name being a special Character. 

IF(OR(ISPICKVAL( Sector__c, "Tate"),ISPICKVAL( Sector__c, "Light + Air")), 
LEFT( 
(Project_Name_2__r.Project_Name_Editable__c 
+ " - " + 
Opportunity_Description__c 
+ " - " + 
Account.H_Account_Name__c), 70) , 


"Q" + "-" + UPPER( Owner.Alias ) + 

LEFT( TEXT( CreatedDate ), 4) + 
RIGHT((LEFT( TEXT( CreatedDate ), 7)), 2) + 
RIGHT((LEFT( TEXT( CreatedDate ), 10)), 2) + "-" + 

RIGHT((LEFT( TEXT( CreatedDate ), 13)), 2) + 

RIGHT((LEFT( TEXT( CreatedDate ), 16)), 2) )