
CHAPTER 10 TASKBUILDER ACTIONS 117
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.
Header String (Value—String) – Creating a dataset in memory will require column
header names. e Header String should contain those column names delimited by
the same delimiter string used in the text le itself. Alternately, the header string can
be placed in the rst line of the text le, and this property le blank. Not providing a
header string in either location will result in the rst line of data being interpreted as
the header string with incorrect results.
Dataset Name (Value—String) – e Dataset Name is the name given to the dataset in
memory. is string is optional, but it is important if the data in memory is going to
immediately be converted into another form.
Table Name (Value—String) – e Table Name is the name given to the data table in
memory containing the data. is string is optional, but it is important if the data in
memory is going to immediately be converted into another form.
Text-to-XML Action
e Text-to-XML action (see Figure 10.14) takes a text le with data elements, delimited by
a string of one or more characters, and creates an XML le organized into the equivalent
of data rows and tables. e text le should have each row of data elements on a separate
line and the data elements should be separated by the given delimiter string without any
additional characters or white space.
Figure 10.14 – Text-to-XML Action
e Text-to-XML action has the following properties:
Delimiter String (Value—String) – e Delimiter String consists of one or more char-
acters, numbers, symbols, or white space that separate each data element within the
text le. is must be consistent throughout the le or the action will fail. Make sure
that the data values themselves do not contain instances of the delimiter string; this will
cause the text le to parse incorrectly.
Commentaires sur ces manuels