Skip to main content
Topics#Data ManagementPergunta de Salesforce Lover
Salesforce Lover perguntou em #Data Management
5 de set. de 2013, 00:10

need help with a formula field

I am trying to write a formula to copy the street address from a custom field which currently contains the complete address like Street, City, State and Zip. 

 

Currently what I could come up with is below but it only works well if the address field value meets the else condition.   

 

IF(ISNUMBER(TRIM(RIGHT(TREES__Address__c, 6))), LEFT(RIGHT(TRIM(TREES__Address__c), 50),33), LEFT(RIGHT(TRIM(TREES__Address__c), 25), 25))

 

Any urgent help will be highly appreciated.
6 respostas
  1. Nauman Khan (Accenture)
    26 de set. de 2013, 21:34
    Since this question isnt marked resolved, I ll give my shot too.

     

    Dan's solution is pretty close but try the below syntax in your formula field..

     

    SUBSTITUTE(LEFT(TREES__Address__c,FIND(",",TREES__Address__c)),",","")

     

    Hope this helps.
Escrever uma resposta...
0/9000