Skip to main content
Topics#Data ManagementSalesforce Lover의 질문
Salesforce Lover 님이 #Data Management에 질문했습니다
2013년 9월 5일 오전 12: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개
  1. Nauman Khan (Accenture)
    2013년 9월 26일 오후 9: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.
답변을 작성하세요...
0/9000