Convert csv single coulm to multiple columns


#1

Hi guys,
I am writing a datatable to csv file and later applying formula based on column values…
In order to apply formula. I had to use write cell…which can only be used within excel application scope.

So i opened my csv file using excel application scope and then applied formula using write cell method.
So far so good.

Now when i open the same csv file… all colums and its corresponding values are merged into single column.

I have further process to be applied on this csv file.
I know i can use text to data option of excel to separate the columns…but i was wondering if there is way to do the same using uipath?


#2

Got this working by
1.reading the output csv via read text command…and saving output in text
2.then writing to another temp csv file via write text command but with a "sep=~"appended to the text string.