Hi,

I am  trying to extract text after the last "." used in the value for the text field (External_Product_Name__c) and putting them into formula field (Pure Product Name__c) 

So I want to take the text out of this: 

SuP.53356.BLACK/BLACK INK.Chrome cool Sleek stylus pen

To this: 

Chrome cool Sleek stylus pen

I want to take the last "." into consideration not first or second. 

Last time I used something like that for other issue: 
 

IF(left(Product_Name__c,2) ='S-',MID(Product_Name__c, 3, LEN(Product_Name__c)),
IF(left(Product_Name__c,2) ='RSMPL.',MID(Product_Name__c, 7, LEN(Product_Name__c)),

Product_Name__c)))

However, this is purely based on position of last "." in the text.  How can i take last "." into account while building the formula? 

Thank you, 
Mit

 

Hi,

I am  trying to extract text after the last "." used in the value for the text field (External_Product_Name__c) and putting them into formula field (Pure Product Name__c) 

So I want to take the text out of this: 

SuP.53356.BLACK/BLACK INK.Chrome cool Sleek stylus pen

To this: 

Chrome cool Sleek stylus pen

I want to take the last "." into consideration not first or second. 

Last time I used something like that for other issue: 
 

IF(left(Product_Name__c,2) ='S-',MID(Product_Name__c, 3, LEN(Product_Name__c)),
IF(left(Product_Name__c,2) ='RSMPL.',MID(Product_Name__c, 7, LEN(Product_Name__c)),

Product_Name__c)))

However, this is purely based on position of last "." in the text.  How can i take last "." into account while building the formula? 

Thank you, 
Mit