+ Start a Discussion

Split custom address textarea field into different fields using formulas

In a managed package, there is a custom object for Address which is a text area.  I need to create formula fields that will yield the Street, City, etc.  In the managed field, they are separated by line breaks.  How can I search for the line break character using a formula to separate it?
Thank you
Hi OcoBri,

try this link 

 And go through with MIKE_DAY reply in the link it will give you the solution you are looking for.
Hope this will help you.

That would not help, because I don't want to change all of my data by adding a comma to the end of the city name, etc.