0

Convert Collection to Text

  • updated 1 mth ago

Description

This part allows you to convert the contents of a collection to a text string.  As an example, this part is used to manage data, for instance in running a data table query as follows:

select governer from state_table where state on ("NY", "DC", "HI")

Typically, this part is NOT used for formatting a collection as text to show on the screen, as both report-item (Assessment Framework) and format variable (all frameworks, standalone) offer a wider range of choices for display.

 

Tips and Tricks

This part is good for converting a simple checklist to comma delimited or other simple text format.
For more sophisticated separators or creation of an HTML structure for bullet lists, etc. use the Format Data Object part instead. 

Editor Fields

This part uses the following editor fields: 

Tab

Field Name

Description

Type/Options

Optional/Mandatory 

Basic

Input path

This is the name of the collection for the system to convert.

Text

Mandatory

Basic

Separator

This is the symbol the system should use to separate the returned values. The default value is a comma (',').

Text

Optional

Basic

Add quotes around value

This setting tells the system to add quotation marks around the returned values. The default setting is 'no'.

No | Yes

Mandatory

Basic

Output path

This is the name of the data object into which the converted text will be stored.

Text

Mandatory

Example

For an example of how to use the Convert Collection to Text part, download and import the following sample project in your workspace.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 4 yrs agoLast active
  • 37Views
  • 3 Following

Home