Converting Spaces to Underscores
Within data load and dimension build rules files, you can convert spaces within fields to underscores; for example, New York to New_York.
To convert spaces to underscores:
Open or create a rules file.
Select a field.
Select Field, and then Properties.
In the Field Properties dialog box, select the Global Properties tab.
Select Convert spaces to underscores.
Click OK.
Related Information