Fixed Width Column Extracts

Extracts can output rows of data using columns with a fixed width instead of a delimited format.  The Delimiter Character extract option can be set to None - Fixed Width to produce a fixed width output.  The width of each extract column is determined by the maximum length defined for the property being output.  Constant columns use the length of the specified constant value and specialty columns have predefined widths based on data type.  Values in fixed width columns are padded with a space character.

Business Benefit: Enterprise Data Management can produce extract files that are directly consumable by enterprise systems which require a fixed width column file format.  A TreeMover file for Peoplesoft is an example where fixed width columns are used.

Key Resources