Transforming the data

The text file can be updated directly by manually replacing the source language field description with the translated text, then saving the changes after completing the update.

The most efficient way to update the fields is using the power query editor in Excel. To do this, open Excel, navigate to the Data tab, then select Get Data followed by From Text/CSV.

Select the downloaded txt file and select Import.

Select Transform Data then select the Transform tab, select the Split Column option by delimiter and maintain the below split by delimiter settings.

After selecting OK, the screen field description will be separated from the string.

Select File then Close and Load.

Add a new column to the right and start translating the screen field descriptions.

After completing the translation, save the file as a new .txt file. The translation can then be uploaded back into SAP.

Note

Ensure the file only contains the target language when saving.

It may also be necessary to split the menus, function codes and exception codes into a separate .txt file.