FPExporter -> FixedLengthExporter: wrong fixed space(tab)

[Mascarian]

Hello,

While attempting to export data (using FixedLengthExporter) to a fixed length format (Tab separated values), I am encountering an issue when examining the generated file, this issue is an inconsistent (space) length between the values.

Expected behavior is:

Column1 [TAB SPACE] Column2 .... [TAB SPACE] ColumnN      (N being the last column number :| )

However, I am seeing (almost) random spaces (or random number of tab spaces). See attached screen shot for an example.

Any ideas?

Many thanks!

[wp]

If you want TAB-separated values then you need the CSVExporter. In spite of its name (CSV = comma-separated values) you can define the field separator to be a TAB-character by changing the property FormatSettings.FieldDelimiter.

The FixedlengthExporter, on the other hand, would write a file in which the columns have specified widths. Narrower field values are expanded to the requested column width by adding spaces.

[Mascarian]

wp,

You sir are definitely a hero. Thank you.