Cómo puedo extraer el texto de un archivo .txt, pasarlo a un documento Ecxel y que me lo acomode en diferentes columnas?
The order would be like this
- Read the data from text file using read text file activity.save the output as str
- Now use generate datatable and pass str input and get dt datatable output… for this you have to give row and column sperators according to your data
- Write dt to excel
Cheers
1 Like