Convert text file(Notepad) to Excel using Blue Prism

Armada

New Member
This is the text that I need to convert. I tried to put it in a Data Item and then using Split Text to split it. The result is saved in a Collection. Is there any way to throw this text in a collection without losing its structure?

1615885459425.png
 

Armada

New Member
Thank you, but I found the solution. Here it is.
Firstly I converted text separated with | to CSV: Read All Text From File, Replace | with ; (using a Calculation Stage), Write Text File
Secondly I converted CSV to EXCEL: Create Instance, Create Workbook, Import CSV, Get Worksheet As Collection, Save Workbook As.
 

dileep2418

New Member
Thank you, but I found the solution. Here it is.
Firstly I converted text separated with | to CSV: Read All Text From File, Replace | with ; (using a Calculation Stage), Write Text File
Secondly I converted CSV to EXCEL: Create Instance, Create Workbook, Import CSV, Get Worksheet As
Please describe in detail the steps you took to complete the task in Blueprism.
 
Top