Convert text file(Notepad) to Excel using Blue Prism

#1
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
 
#3
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.
 
Top