Skip to main content
Topics#Desktop IntegrationAndrii Volkov's Question
Andrii Volkov (SWIVL) asked in #Desktop Integration
Mar 31, 2021, 9:12 AM

Formula field which removes all text characters in brackets and brackets

Hi! I need to right a formula field that takes input from one of the existing fields and removes extra information it has in brackets including brackets itself and extra space to give it a cleaner look, like so: "ABC Co (New York, NY)" => "ABC Co". Please advise.
2 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Mar 31, 2021, 9:36 AM
    Hi Andril,

     

    Will the bracket bit always be on the right hand side? Will there always be only one start and end bracket? If so:

    LEFT(Field__c, FIND("(", Field__c)-1)

     

    ​​​​​​​
Write an answer...
0/9000