2022.1

l Date Format: Set the date format for a date value.
l Automatic: Select this option to parse dates automatically, without specifying a
format. This is the default setting for new Date fields.
l ISO8601: This setting allows for dates with different timestamp formats, or belonging
to different time zones, to be parsed inside a single job. Dates that do not include a
specific time are automatically considered to use the current locale's time zone.
Select the ISO template to be used when parsing the timestamp. Other ISO8601
formats can be handled via the Custom option.
l Custom: Set a custom date format. For the markers available in the DataMapper
see "Defining a date/time format" on page314.
l Language: Set the language for a date value (ex: If English is selected, the term May will
be identified as the month of May).
l Use offset from UTC: Select the default time zone, which is to be used to extract any
timestamp that does not already include time zone information with the time.
l Treat empty as 0: A numerical empty value is treated as a 0 value.
Order and rename fields dialog
The Order and rename fields dialog displays the extracted fields in the currently selected
Extract step.
To open it, first select an Extract step on the Steps pane. Then, on the Step properties pane,
under Field Definition, click the Order and Rename Fields button next to the Field List
drop-down.
Field extractions are executed from top to bottom.
In JavaScript-based fields, it is possible to refer to previously extracted fields if they are
extracted higher in this list or in previous Extract steps in the extraction workflow.
l Name: The name of the field. Click the field name and enter a new name to rename the
field.
Page 376