Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (12.7k points)

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

1 Answer

0 votes
by (29.5k points)

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
    - Text to Split: <data item containing your comma-separated list>
    - Split Char: ", "
    - Collection Field Name: <string name of your choosing>
    - Split Values (single-column collection)

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories