How to extract each words separated by comma in a text using Blue Prism?

Question

Given the string "House, Building, Farm, Office", how can I extract each word and store them in a collection in Blue Prism?

Answer 1

One way to go about this would be Importing the bundled Utility - Strings Business Object from <Blue Prism install dir>/VBO/BPA Object - Utility - Strings.xml and use the Split Text action to get each of the comma-separated strings as an individual collection row.

Then it would look something like this

Object: Utility - Strings
Action: Split Text
Inputs:
    - Text to Split: <data item containing your comma-separated list>
    - Split Char: ", "
    - Collection Field Name: <string name of your choosing>
Outputs:
    - Split Values (single-column collection)