Home → Star Bill of Lading → Setup → Concatenating City, State, and Zip fields while importing Consignees

5.10. Concatenating City, State, and Zip fields while importing Consignees

To concatenate the fields using the import wizard you need to use this during
the import option.  Run the Import option, then during the mapping portion, 
you need to key in the following into the mapping Source associated to the 
proper address field.

(C + ", " + D + "  " + E)

Where C = City
Where D = State
Where E = Zip

This is based on the assumption that you are using an Excel spreadsheet to 
import.  Other file types are done the same way.

Here is the Expression builder in the import process.

This is what the Mapping screen looks like after you build the import expression.

Click Next. You will see the Data preview screen. Click Next.

Select your Import mode and then Execute. 

You should be taken back to the main screen.