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,750 points
1,505 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
• 56,520 points

Related Questions In RPA

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 in RPA by Shivi Singhal
3,051 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 in RPA by Abha
• 23,030 points
229 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
86 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 in RPA by Ishan
423 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
• 56,520 points
1,491 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
• 56,520 points
4,127 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
• 56,520 points
844 views
0 votes
1 answer

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

I've done this, but I dont have ...READ MORE

answered Oct 5, 2018 in RPA by Priyaj
• 56,520 points
1,682 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 in RPA by siva cynixit
1,444 views