I would like to save all the files inserted in this zip folder
ricevute_del_2018-06-07-153046.zip (1.2 KB)
in a single Excel file with successive rows and separate columns.
Can you help me in excecuting this?
Thank you so much,
Just to understand more, each file has 2 lines of data, so overall you want your data in 10 rows in an excel and for columns what is the delimiter( separator ) is it “;” if not what else ?
the file doesn’t have a fixed number of lines.
The delimeter for the columns is the “;”.
Thank you so much.
What you will need to do is use .GetFiles() to store the text files in a list.
Then, use Append Text to combine them to one string.
Then, replace all commas with something else (if they have commas), and replace the “;” with the “,” comma so it will be a comma-delimitted text.
Then, finally you can just use Write Text File and use “.CSV” as your extension, which will place the file into a table format (which you can use with Read CSV or whatever else.
For each file In System.IO.GetFiles("directory","*.txt") Append Text // using file Assign text = text.Replace(",",".").Replace(";",",").Trim Write Text File // using appended text with ".CSV" extension Read CSV // if you want the data table. If not, then you are done
So I hope this helps.