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

0 votes
I have an Excel spreadsheet that has various columns with their respective data. I need to take column "A", and split the example text "[11111] Dog" into TWO columns: "A" that now has "[11111]", and "B" that now has "Dog". Is there a way to do this within Blue Prism?

I have already used an action to gather the data into a collection, but am unsure of the next steps to execute what is desired.
Oct 15, 2018 in RPA by findingbugs
• 4,780 points
4,050 views

1 answer to this question.

0 votes

This is how I am doing it.

Dim wb, ws, range, excel as Object

wb = GetInstance(handle)
ws = GetWorkbook(handle, WorkbookName).ActiveSheet.Range(cellref,cellref).Activate()
excel= ws.Application

range = ws().Selection.TextToColumns(OtherChar, Other)
answered Oct 15, 2018 by Priyaj
• 58,090 points

Related Questions In RPA

0 votes
2 answers

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

Import the bundled Utility - Strings Business ...READ MORE

answered Jul 2, 2020 in RPA by Kim
2,592 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
13,860 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,275 views
0 votes
0 answers

How to use Global Send Keys in Excel in Blueprism

Hi, I have material copied to the ...READ MORE

Apr 4, 2019 in RPA by Ishan
4,645 views
0 votes
1 answer

How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 63,420 points
855 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,090 points
5,257 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,090 points
15,912 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,277 views
0 votes
2 answers

Blue Prism- How to retrieve data from webpage

The ideal way to accomplish this would ...READ MORE

answered Sep 13, 2019 in RPA by siva cynixit
6,154 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