You need to sign in to do that
Don't have an account?
Help with formula field
Hi
I need help with formula field. Right now i have a fields called "Mailing Name" and i have to bring a part of text from that field into a formula field.
Ex:
Mailing Name : India CO (243)
I just want the number in the brackets in the formula field. I tried to create one like the below
MID(Mailing_Name__c, FIND("(", Mailing_Name__c), FIND(")", Mailing_Name__c)) but the output for the formula field ia (243) and i just want the number not the brackets.
Is there any other way of creating this formula field where i can just pull the number in the brackets of the Mailing Name field.
Thanks
As long as the number of characters between the () are no more than 5, this will work. If it could ever become 6, then you need to change the 6s in the formula to 7s.
All Answers
Does the Mailing Name field always end in (###)?
This should give you only the number if the field always ends in (###).
Thanks. The mailing name fields has a number which starts and ends in brackets but the number will not be always 3 digit length. It can be even 4 or 5 digit number or sometimes 2 digit too. You formula fields pulls the correct number if the number in the brackets is 3 digits.
Thanks
As long as the number of characters between the () are no more than 5, this will work. If it could ever become 6, then you need to change the 6s in the formula to 7s.
Thanks for your reply.
It worked perfect. Can i just give 10 instead of 6 just to be on the safe side.
Thankyou so much.