I have created a custom object and I am using dataloader to insert the data. I am not sure how to insert the billing and shipping address, which consists of more than one column of data in the csv file, into the corresponding text area field in the custom object.
Example:
Billing Address line 1: Attn: Accounts Payable
Billing Address line 2: 1 Book Lane
Biling City: Redwood City
Billing State: CA
Billing Zip: 94063
Needs to be inserted into the Billing Address text area field.
답변 2개
Hi Lakisha,
You will have to use Excel to concatenate those fields into a single column if the Address field on your custom object is a single field.
Here is some excel help on concatenating text cells: https://support.office.com/en-au/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d?ui=en-US&rs=en-AU&ad=AU (https://support.office.com/en-au/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d?ui=en-US&rs=en-AU&ad=AU)
