How to output a fixed width file

There is currently no specific fixed width file output type. But you can output fixed width files.

If we have a dataset like this:

v1 v2
a 1
bb 11
ccc 111

And we want to output it with v1 column 10 characters wide and v2 column 5 characters wide, we can do it like this:

fixed-example.transform (3.7 KB)

If there is any possibility that there might be too many characters in a column you can either:

  • Use Extract to remove the excess characters.

fixed-example2.transform (5.3 KB)

or

  • Use Verify to cause processing to fail if there are too many characters in a column.

fixed-example3.transform (5.7 KB)