Transformation file padding
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.