You need to sign in to do that
Don't have an account?
MC34
Parsing specific texts from the field value.
Hi,
I am trying to extract the specific portion from the values from the text field (Product name) and putting them into formula field (Actual Product)
The formula I am using this:
Formula field | Text field
Thank you
I am trying to extract the specific portion from the values from the text field (Product name) and putting them into formula field (Actual Product)
The formula I am using this:
SUBSTITUTE(SUBSTITUTE(Product_Name__c ,"S.", ""),"S-", "")However, at the end of some values I have US.01 and the formula is also parsing the values and resulting in U01 which is not desirable. Is there a way to tweak the formula that it only does that for start of the values for "S." and "S-" Not at the end?
Formula field | Text field
Thank you
Try this:
IF(Left(Product_Name__c,2) ='S.',MID(Product_Name__c, 3, LEN(Product_Name__c)), IF(left(Product_Name__c,2) ='S-',MID(Product_Name__c, 3, LEN(Product_Name__c)),Product_Name__c))
If it is not 3, try with 2 or 4.
If it helps please like and mark as correct as it may help others asking the same.
good luck
All Answers
If it helps please like and mark as correct as it may help others.
If I use "Remove the first 2" criteria then it will also remove the first two characters from other values that do not start with "s." or "s-". for example some product names start with 19.... or numbers.
Try this:
IF(Left(Product_Name__c,2) ='S.',MID(Product_Name__c, 3, LEN(Product_Name__c)), IF(left(Product_Name__c,2) ='S-',MID(Product_Name__c, 3, LEN(Product_Name__c)),Product_Name__c))
If it is not 3, try with 2 or 4.
If it helps please like and mark as correct as it may help others asking the same.
good luck
Agustin B - Can you please help me something regaerding this?