Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

Collection of Objects From String

This activity splits the InputString parameter based on the Separator parameter and builds a collection of Object items as output.

Activity Parameters

The Collection of Objects From String activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Input String (text box editor type) (type: string): the input string that you wish to separate with Separator parameter to obtain a collection. It can be manually written or bound to a declared variable.
  • Separator (text box editor type with "¥" as the default value) (type: string): the separator used to separate the input string to obtain a collection. In the example above there can be seen the ; (semicolon) used as separator.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output Collection (type: collection<object>): outputs a collection of type object containing the separated elements from the input string.
  • Output Count (type: int32): outputs an integer equal to the collection count.

 

Execution and activity usage:

  • the activity splits the input string based on the given separator:



  • the activity will output a collection, which will contain the elements retrieved after the split operation. The output collection can be iterated using a ForEach activity and the results displayed using Log Track Data activities:



    • For Each: takes as input the output Collection from the Collection Of Objects From String activity:



    • Log Track Data activities can output values for Key and Value items:





  • The results will be displayed in the Track Data area:

 

 

Get Element From Collection

This activity returns an element from a specified index from the given Input Collection.

Activity Parameters

The Get Element from Collection activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Filter Index (text box editor type) (type: string): the index of the column from where you wish to extract the element (can be an integer or one of the name indexes specified in the 'Name indexes' parameter). If no value is specified, '0' is set by default.
  • Input Collection (text box editor type) (type: collection<collection<string>>, string, any collection type): the input collection. Bind this parameter with a collection type Output parameter from an activity.
  • Name Indexes (text box editor type) (type: string): the name of the column indexes of the current collection, separated by comma ','.

As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Collection of Objects From String activity:

The Read Only Output variable are the possible output values that the activity will provide:

  • Collection Count  (type: int32): outputs an integer equal to the collection count.
  • CSV String  (type: string): outputs a string containing the elements of the collection separated by ','.
  • Element  (type: string): outputs the string value of the element indicated by the 'Filter index' parameter.
  • Element Object  (type: object): outputs the element indicated by the 'Filter index' parameter.

 
  • No labels