Demand Tools Tips & Tricks - Concatenating multiple lines of address data
Thursday, June 13, 2013
Concatenating multiple lines of address data so that when inserted they will appear on multiple lines just as if they were entered directly via the Salesforce user interface
Do you have AddressLine1 and AddresLine2 in two columns on your input spreadsheet, and want to insert both into Salesforce? When inserting via the API (DT and/or PI) there is only one street address line to map to; whereas in Salesforce multiple lines of street address appear on separate lines. You can insert your data to match the Salesforce format by concatenating the fields in your spreadsheet separated by a carriage return.
- Create a new column in your spreadsheet for the full street address
- Type the following formula in the first cell in the new column =A1&char(10)&B1 (assumes AddressLine1 and AddressLine2 are in A1 and B1 respectively, adjust the formula based on your columns)
- Now cut and paste the formula down all the rows of data
- Lastly, do a copy and paste special (values) over the new column, so that the actual values are in the column vs. the formula
- Map this concatenated address into the appropriate street address of your table
posted by A Miller @ 2:42 PM,
