Dropping Spaces around Fields
Within data load and dimension build rules files, you can drop leading and trailing spaces within fields.
To drop leading and trailing spaces:
Open or create a rules file.
Select a field.
Select Field, then Properties.
In the Field Properties dialog box, select the Global Properties tab.
Select Drop leading/trailing spaces.
Click OK.
Related Information