Symptom
You have executed a migration and noticed that special characters   were migrated instead of spaces in certain fields.
Environment
- SAP Business ByDesign.
Cause
Since a space at the end of a name is irrelevant, the system interprets the space in its HTML number (i.e.  ). The same occurs if a space is added after the name and before a bracket; since a name cannot have a bracket, the system interprets the space before the bracket in its HTML number as well.
Resolution
In the migrated record, the solution is to simply edit the field and remove the   from its value. In order to avoid this on further migrations, remove any unnecessary spaces from the template and this should no longer occur.
For larger datasets you may consider to utilize Excel's Find & Replace functionality as follows:
- Select affected cells.
- CTRL+H to display find/replace dialog.
- Find: ALT+0160 (Hold the ALT key and enter numbers via numeric keypad).
- Leave the Replace field blank.
Keywords
Spaces,  , Migration , KBA , LOD-LE-MIG-MWB , LEAP Migration workbench , How To