For USA country region, the default address will look like this:
In order to correct this formatting and provide space between city and state and zip code.
->/Organization administration/Setup/Addresses->Address Setup
In Country/Region tab, check the Address Format number that’s associated with the country related to your legal entity.
Change Address Format 0008:
Append a space in the Seperator column for “City“
Append a space in the Seperator column for “State or province“
Click “Save” in the “Configure address component” tab
Click “Update address” and run the batch.
All addresses are stored in table LogisticsPostalAddress.
All addresses are fetched from view LogisticsPostalAddressView.