+ Start a Discussion
OcoBriOcoBri 

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
@anilbathula@@anilbathula@
Hi OcoBri,

try this link 

https://developer.salesforce.com/forums/ForumsMain?id=906F00000008w5HIAQ
 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.

Thanks
Anil.B
OcoBriOcoBri
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.