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,156 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,160 points

Related Questions In RPA

0 votes
3 answers

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

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
2,059 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,090 points
59 views
0 votes
1 answer

Using GLobal Send Keys how to send PrtScr in Blue Prism?

Navigate stage with Global Sendkey and text ...READ MORE

answered Oct 24, 2018 in RPA by Priyaj
• 56,160 points
1,515 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
183 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,160 points
943 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,160 points
2,945 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,160 points
699 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,160 points
1,342 views
0 votes
1 answer

Blue Prism- How to retrieve data from webpage

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

answered Oct 17, 2018 in RPA by Priyaj
• 56,160 points
972 views