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,730 points
793 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,100 points

Related Questions In RPA

0 votes
2 answers

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

1. First use the excel application scope ...READ MORE

answered 3 days ago in RPA by Venkat
• 260 points
1,093 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
37 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,100 points
1,154 views
0 votes
1 answer

How to automate Citrix based applications in Blue Prism?

Hi Bilal, Surface Automation techniques with Region ...READ MORE

answered Mar 18 in RPA by Anvi
• 5,680 points
144 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
54 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,100 points
604 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,100 points
1,895 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,100 points
567 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,100 points
980 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,100 points
590 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.