Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transformation file padding

Hello Experts

In the 'Mapping Section' of a Transformation file, is it possible to combine the Column Index function with the PAD function used for padding imported fields?

Through the Transformation File, a string of text is derived by concatenating several columns, see example below:


This produces a string of text such as:


Each column is shown using the pipe delimiter:


Some fields are variable in length.  This can produce a string of text that may be identical to another but in fact has a very different meaning and should be handled differently by the Conversion File.

Using the same example, those Columns I have highlighted in bold are variable length and need to be padded (to the left) so that they become a fixed length 2 digit field.


Ideally this would produce a string of text like this:


I have used pipes to separate the constituent parts:


The letter 'P' is used to Pad the field.

I have tried the following formula but the Transformation File will not validate.


Any suggestions would be much appreciated.


Former Member
Not what you were looking for? View more on this topic or Ask a question