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,790 points
2,319 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
• 57,530 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 in RPA by Kim
46 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
5,557 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
• 27,910 points
1,932 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
1,676 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
• 57,530 points
2,915 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
• 57,530 points
8,584 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
• 57,530 points
1,350 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 2 days ago in RPA by jananidhamu98@
• 550 points
2,441 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
3,216 views