How do I split excel column data into TWO columns with Blue Prism

Question

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.

Answer 1

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)