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

0 votes

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

Jul 1, 2020 in RPA by Anil
• 120 points

recategorized Jul 2, 2020 by Gitika 2,942 views

2 answers to this question.

0 votes
Sounds like you are opening a CSV file in Excel. You could try reading the file directly with Utility - Strings.Get CSV As Collection
answered Jul 2, 2020 by Sirajul
• 59,230 points
0 votes
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)
answered Jul 2, 2020 by Kim

Related Questions In RPA

0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,020 points
4,383 views
0 votes
2 answers

how can i add collection data to csv in blue prism?

Use the utility something which contains Get ...READ MORE

answered Jul 10, 2020 in RPA by jananidhamu98@
• 550 points
4,708 views
+2 votes
1 answer

How to extract data from website and save it to excel using Blue Prism?

Hey, you can use following steps to ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,140 points
6,850 views
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,110 points
971 views
0 votes
1 answer

What is code segment in Blueprism and how to implement it?

Blue Prism - Code Stage The code stage ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 58,020 points
5,716 views
0 votes
1 answer

Error : Failed to perform step 1 in Navigate Stage '-----' on page '----' - Not Connected

Do you have Attach bookmark created? When ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 58,020 points
16,712 views
0 votes
1 answer

Spy an active accessibility combobox in blue prism?

My ComboBox is standard HTML Combo Box(Element ...READ MORE

answered Oct 1, 2018 in RPA by Priyaj
• 58,020 points
3,317 views
0 votes
2 answers

RPA tool for C# Developer beginer

Hi! You can try Rpa Suite for Visual ...READ MORE

answered May 10, 2019 in RPA by AndrewNJ
4,564 views
0 votes
1 answer

RPA : How to extract specific data from scanned pdf and write into excel in blueprism?

Your query is similar to https://www.edureka.co/community/6509 ...READ MORE

answered Mar 23, 2020 in RPA by Sirajul
• 59,230 points
2,286 views
0 votes
1 answer

Please explain different Skills in Blue Prism with a use case

There's a blog that explains a couple ...READ MORE

answered Apr 17, 2020 in RPA by Sirajul
• 59,230 points
1,052 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP