Skip to main content
Topics#Data ManagementQuestion de Salesforce Lover
Salesforce Lover a posé une question dans #Data Management
5 sept. 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 réponses
  1. Nauman Khan (Accenture)
    26 sept. 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.
Rédiger une réponse...
0/9000