- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
07-30-2008 08:25 PM
Is it possible to write a formula that essentially breaks the shipping address down into the individual lines?
We have an external system that needs to receive the address fields for a child object to an Account in three separate fields.
I figure if I can identify a new line character, then this should be pretty straight forward, but I can't figure out how to do this.
Solved! Go to Solution.
07-30-2008 09:15 PM
I'm not sure what you mean. Inside SFDC, the address field is really seperate fields:
My Blog: http://forcemonkey.blogspot.com
07-30-2008 10:13 PM
thanks for the response.
I'm trying to break the shipping street into individual lines.
At the moment it appears to be a text area with multiple lines.
The other items are all fields unto themselves, so they should be fine.
07-31-2008 05:56 AM
07-31-2008 07:53 AM
I might have to just add in some commas as delimeters to the shipping street lines.
Should be able to easily split them up this way.
Was just hoping there might be a more standard way of doing this, or a way to detect a new line character.
01-02-2009 05:20 AM
Did you ever solve this issue? When I access the Shipping Address field via the API to send the shipping address to an external file the lines are joined without spaces. Ideally I'd like to split the shipping address into 3 fields using the line break character to do the split. I thought I could use a RegExp to do this but none of the usual line break characters seem to work - eg. \n
01-04-2009 04:02 PM
Unfortunately we never found a way around this.
We have an external system that accesses this field and the string comes through with some form of line break in it that our coders have managed to use to separate the address lines.
Not sure of the exact details, but I think there is either a <br> or some form of line break character that is used.
08-10-2009 10:41 AM
I'm having similar problems accessing the lines in StreetAddress in Pages. The problem is that APEX:outputField will preserve line breaks but doesn't maintain font settings. APEX:outputText will do respect font settings but not line breaks.
Since City, State, Zip, & Country are accessabl, it would be nice if the Address1, Address2, Address3 were as well.
02-01-2010 02:12 PM
When you enter an address in the "Address" field, if the user clicks enter to add a new row, SFDC saves the info in those 3 split address lines.
So if you type in the address field:
Street address (click enter)
Floor (Click enter)
Apt (Click enter)
This is what you will see in those extra fields:
Address Line 1: Street Address
Address Line 2: Floor
Address Line 3: Apt