Within data load and dimension build rules files, you can split one field into two fields. For example, you can split the UPC100-10-1 field into the UPC field and the 100-10-1 field.
To split one field into two fields:
Open or create a rules file.
Select a field.
Select Field, then Split.
In the Split Field dialog box, in Number of characters in a column, enter the number of characters to place in the first of the two fields.
The remaining characters are placed in the second field.
Click OK.
The first field is displayed to the left of the second field.
Related Information