Unstructured text file convert into excel file

Help
, ,
1

Hi Folks !!

I have unstructured text file, which I need convert into excel file. If you anybody know please share thoughts. How should I do ? What are all activities need to use it for this action.

I have done one step in uipath.

  1. Through Assign activities, I read the text file and store into string variable.

Could you advise me, how to write into “Data Table” and same output I need write into excel file as well.

2

@Jagadeesanp,

Check this xaml, it will get all the text files form a directory and process one by one. You can check with this and get some idea and then implement your solution as you want.
TextToExcel.xaml (13.2 KB)