Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in RPA by (12.7k points)

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.

1 Answer

0 votes
by (29.5k points)

You can refer the code below to solve your issue:

 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.TextToColumn s(OtherChar, Other)
 

Browse Categories

...