Search found 6 matches

by simon1516
21 Dec 2017 01:44
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Re: Automatically copy data from a text file into excel

Hello SIMMS7400,

I wanted to ask again friendly, if you help me even further :-)

regards,

Simon
by simon1516
08 Dec 2017 02:29
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Re: Automatically copy data from a text file into excel

Hello guys,

do i have to give more informations?

it would be great, if someoe could help me :-)

king regards,

simon
by simon1516
07 Dec 2017 06:06
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Re: Automatically copy data from a text file into excel

Hello SIMMS7400, Unfortunately, I could not copy a text document in the appendix. so i copied the content from an example .txt. You will often find the entry "random_number" there. these values ​​I would like to end up next to each other, in columns in an excel table :-) In the following content the...
by simon1516
07 Dec 2017 02:03
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Re: Automatically copy data from a text file into excel

Hello everybody, thank you very much for your help. Now, however, the entire content of the text file is copied to excel. I would like, however, that only certain values ​​are copied, which occur as follows in the text file: Random number: 'A2 8D 75 31' in this example column 1 of excel file should ...
by simon1516
06 Dec 2017 06:28
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Re: Automatically copy data from a text file into excel

Hello SIMMS7400, thank you very much for your help. I try to give you some Information :-) As soon as I try to open the generated excel file, I get the following error message: the file "temp.xlsx" can be opened by excel nciht because the file format or the file extension is invalid. Check if the fi...
by simon1516
06 Dec 2017 02:03
Forum: DOS Batch Forum
Topic: Automatically copy data from a text file into excel
Replies: 11
Views: 17181

Automatically copy data from a text file into excel

Hello everybody, I would like to have data from a text file (.txt) automatically written to an Excel spreadsheet. The text file looks something like this: bla bla bla bla bla bla bla bla bla random_number:'xyz' bla bla bla bla bla bla bla bla bla random_number:'abc' Now the result should be an excel...