Skip to Content
avatar image
Former Member

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 22, 2014 at 12:18 PM

    Hi Ian,

    But what do you mean by (in bold):



    Add comment
    10|10000 characters needed characters exceeded