Generate Fixed-width Output using xFusion Studio
Sheetal Dehadaraya
You can easily generate fixed-width format files using xFusion. The trick is to create an output table of just one column. You build this column using “Format” function. For example, let’s say the required width of the first field is 10 and the required width of the second field is 3.
You will build a new column definition
as follows:
Format([Table1.FirstName], “10”) + Format([Table1.Age], “d3”)
If you want the string values to be left justified, use -10 instead. Use "d" to format numbers.
This results in an output table with just one column. However, within this column all the fields are defined as fixed width. Simply export this table to a text file.
Download the sample fusion pack from here
|
|