Excel contains complete data with separator how to split in blue prism

Question

For Example my excel sheet contains billing address like navadeep,andra,gachibowli,hyderabad,500050 how do i split this as individual

Answer 1

Sounds like you are opening a CSV file in Excel. You could try reading the file directly with Utility - Strings.Get CSV As Collection

Answer 2

Import 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.

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)