Specifying Formats at Stage Level

Stages that have a Format tab on their editor allow you to override the project and job defaults for date and time and number formats.

These stages are:

  • Sequential File stage
  • File Set stage
  • External Source stage
  • External Target stage
  • Column Import stage
  • Column Export stage
  1. Open the stage editor for the stage you want to change and go to the Formats tab on either the Input or Output page (as appropriate).
  2. To change the decimal separator, select the Decimal category under the Type defaults category in the Properties tree, then click Decimal separator in the Available properties to add list. You can then choose a new value in the Decimal separator box that appears in the upper right of the dialog box.
  3. To change the date format, select the Date category under the Type defaults category in the Properties tree, then click Format string in the Available properties to add list. You can then specify a new format in the Format string box that appears in the upper right of the dialog box:
  4. To change the time format, select the Time category under the Type defaults category in the Properties tree, then click Format string in the Available properties to add list. You can then specify a new format in the Format string box that appears in the upper right of the dialog box:
  5. To change the timestamp format, select the Timestamp category under the Type defaults category in the Properties tree, then click Format string in the Available properties to add list. You can then specify a new format in the Format string box that appears in the upper right of the dialog box: