
112 CHAPTER 10 TASKBUILDER ACTIONS
e Data-to-Text action has the following properties:
Add Header? (Choice) – Selecting Yes will add a header line at the top of the le. e
header will contain the column names, delimited by the given delimiter string, and fol-
lowed by a carriage return. Selecting No will cause the rst data row to be the rst line
in the resulting text le.
Text Delimiter (Value—String) – e Delimiter String is a string of one or more char-
acters that represents the dividing line between data elements. e delimiter string will
remain consistent throughout the le and can consist of letters, numbers, characters,
or white space. Each row in the dataset will be placed on a separate line inside the text
le, followed by a carriage return.
Note
TaskBuilder will ignore leading and trailing white space when processing properties.
If you would like spaces to be included, enclose the delimiter string in brackets; the
brackets will be ignored when the task is run. Having a delimiter string of three spac-
es between columns can be written as “[ ]” within this property. To include a tab as
part of a delimiter, use the string “{t}” within the property value.
File Operation (Choice) – e File Operation property allows you to select from the
following options when creating a text le:
Append – e new data will be added to the end of the existing text le without
overwriting it; a new text le will be created if one does not already exist.
Overwrite – e new text le will overwrite any previous text le with the given
lename on the system; a new text le will be created if one does not already exist.
Sequential – e new text le will add a timestamp string to the end of the given
lename, allowing new les to exist along-side old les. Each le will have its cre-
ation time and date marked in the lename for easy reference.
Data-to-3 Card Action
e Data-to-3 Card action outputs the contents of the dataset into a text le conforming to
the 3 Card format (see Figure 10.6).
Figure 10.6 – Data to 3 Card Action
Commentaires sur ces manuels