i download Text file from FTP and i want ot convert to Excel file to get data yesterday data from that text but my issue i recive the text as shown below
and from this data i want to copy yesterday data like this
any one have solution for this or if i can convert this to Excel i think it will be easy to get the data
UiPathTeam.FileConverter.Activities for converting the format of any file. you will have to install from manage package from uistudio and also find more information on below link.
Hope this will resolve your problem…happy learning
@byeole.hr Hi, This package doesn’t contains activity for Converting from text file to excel.
Do you know any another package or activity for Converting from text file to excel.
As of there is no activity to convert text to excel
U can read data from text file and write range in excel
@byeole.hr hi, data from text file will be in string format, as for as I know we can’t use string write range activity.
Use Extract Structured data activity for this input is string and output is data table
We have below converter available
Doc to Docx
Docx to Doc
Word to PDF
Xlx to Xlsx
Xlsx to Xls
These are the formats available in the package that I am currently using
i solved this issue like i download the text file From FTP and saved AS csv then from csv converter to xlsx
and working with me fine as i want
Hi, Can you please send your sample file shows converting from csv to excel
Total Doc Converter is a professional solution for converting documents: ( Word, Doc, DocX, DocM, RTF, RVF, or TXT files) into PDF, DOCX, XLS, JPEG, PNG, TIFF, HTML, XHTML, RTF, DOC, TXT in batch. Featuring an intuitive interface design, new users will find that it’s easy to set-up and run conversion projects. For advanced users, the Total Doc Converter can be run via [command line] as well. You can visit site by typing coolutils in google search go to category Total Doc Converter on left bar menu.