Convert Text File into DataTable and store them into excel #uipathstudio #uipath #uipathtutorial

Hi Guyzz, So in this video, i am going to show you How we can convert Text file into Datatable and store them into excel. So, I have a text file which seems very complex. For this file we cannot simply replace space to "," or VBTAB to "," . Because in columns itself extra comma's are present so it leads to extra columns in your datatables. Steps:- i) first we have to replace commas with any special character according to your choice. I used '%%' to replace the commas from the Text file. ii)Then replace VBTAB with ",". iii) Then use Generate Datatable activity and generate datatable. Happy Automation !!! :)