You need to sign in to do that
Don't have an account?
Laura Boyd 18
Splitting Street address across formula fields
Hi,
Due to an intergration we are trying to run between an old third party system and Salesforce, I need to split the value of the street field in Salesforce into multiple formula fields.
Based on another post, I have this working with the below code if the user enters a comma at the end of the line. Ideally though, I want it to do the split based on the "end of the line". Is there some sort of end of line character that I could replace the comma with in my forumla?
Due to an intergration we are trying to run between an old third party system and Salesforce, I need to split the value of the street field in Salesforce into multiple formula fields.
Based on another post, I have this working with the below code if the user enters a comma at the end of the line. Ideally though, I want it to do the split based on the "end of the line". Is there some sort of end of line character that I could replace the comma with in my forumla?
LEFT(BillingStreet, FIND(",",BillingStreet)-1)
Mid(TRIM(BillingStreet), FIND(",",TRIM(BillingStreet))+2, FIND(",",TRIM(BillingStreet),FIND(",",TRIM(BillingStreet))+2) - FIND(",",TRIM(BillingStreet)) -2)
Thanks,
Laura
May I request you please refer the below link for reference.
- https://salesforce.stackexchange.com/questions/90343/how-can-i-split-the-address
Hope it helps.Please mark it as best answer if the information is informative.so that question is removed from an unanswered question and appear as a proper solution.
Thanks
Rahul Kumar