Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SERIESTOTEXT
Functions and Expressions Reference Guide
180
SERIESTOTEXT
The SERIESTOTEXT function converts a contiguous or non-contiguous series to a
text item.
Syntax
SERIESTOTEXT (series-object-expression)
Meaning
SERIESTOTEXT (series_to_convert)
Returns
This function returns a single-text-item.
Returns a text item containing the concatenation of the series of the input
argument, including nested delimiters but excluding initiators and terminators.
Example
In this example, you have the following data that represents bowler
information for a bowling league:
Andrews, Jessica:980206:JBC:145:138:177:159
Little, Randy:980116:BBK:175:168
Wayne, Richard:980102:JBC:185:204:179:164:212
Each record consists of the bowler’s name, the date of their last game played,
a team code and one or more bowling scores. Record is defined as a group
that is infix delimited by a colon.
Using the following rule:
= SERIESTOTEXT (Score Field:Bowler:Input)
the following results are produced, which is the concatenation of all of the
scores for all of the bowlers, even though the scores are not all contiguous
within the data.
145138177159175168185204179164212
However, if the rule was changed, for instance, to concatenate the list of
scores to the bowler’s name: