Description

You are needing to upload data from Excel that has leading spaces in your field. When it is placed in SAP from Winshuttle, the spaces are removed. Using the "Pre-padding" setting is not an option as the values will not always be the same length.

Applies to

Studio 11

Solution

Studio 11 contains a setting that will automatically trim leading spaces in your data. If this is not needed you can navigate to the Options screen > Data Settings > and uncheck "Trim leading" and "Trim trailing" spaces.

For Server follow the below steps.

Login to Server- Program files- Winshuttle- Studio - Look for shuttle rule file .

1. Trim tag set to true (default)
2. Trim tag set to false


Perform these steps in QA server first test and then in Production.