Convert text to excel

Miya — Mon, 08 Aug 2022 19:59:00 GMT

Hi,

I have txt file with comma as delimiter, i want to get them in excel in proper columns, i tried converting text file directly to excel using open workbook but they all seems to appear in same column, can anyone help to get it into separate columns

------------------------------
Miya
------------------------------

RE: Convert text to excel

PabloSarabia — Mon, 08 Aug 2022 22:43:00 GMT

Hi @Miya

First you need to have your CSV file as collection. For this use the VBO "Utility - File Management" and the action "Get CSV Text As Collection". This returns you a Collection with the same format as your text file.

Then, you can use the "MS Excel VBO" to write the new collection inside an Excel. Use the action "Write Collection" for this.

Work with excel sometimes turn hard, here is a video of how to write collection in BP: https://www.youtube.com/watch?v=jaBOowkhQo4

Also, you can use the Action "Import CSV" from the "MS Excel VBO" VBO. The process is similar than the video

Hope this helps you! And if this solves the problem, remember mark as the best answer 🙂

See you in the Community, bye 😄

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

topic Convert text to excel in Product Forum

Convert text to excel

RE: Convert text to excel