Tech Support Forum banner
1 - 4 of 4 Posts

· Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
I got an output file from a testing machine that I need to clean up a bit before importing into some spreadsheet..

Code:
"VarName"    "TimeString"    "VarValue"    "Validity"    "Time_ms"
"VALUES_A"    "2021-10-25 09:57:32"    10500    1    44494414962.465279
"VALUES_B"    "2021-10-25 09:57:32"    59.282589    1    44494414962.488426
"VALUES_C"    "2021-10-25 09:57:32"    7.522789    1    44494414962.488426
"VALUES_D"    "2021-10-25 09:57:32"    7.880400    1    44494414962.500000
"VALUES_E"    "2021-10-25 09:57:32"    8.337399    1    44494414962.500000
"VALUES_F"    "2021-10-25 09:57:32"    9.523390    1    44494414962.534721
"VALUES_G"    "2021-10-25 09:57:32"    16.065742    1    44494414962.534721
"VALUES_H"    "2021-10-25 09:57:32"    18.799999    1    44494414962.546295
"VALUES_I"    "2021-10-25 09:57:32"    "2013-03-14 21:30:32"    1    44494414962.546295
And I want it to be something like this
Code:
2021-10-25 09:57:32, 10500, 59.282589, 7.522789, 7.880400, 8.337399, 9.523390, 16.065742, 18.799999
I know it's possible, but it a bit out of my skills set :) , getting to old...

Input file are a simple TXT file, output can be the same or a csv file.
Are of course many more lines in the input file..
Needs to run on a Win10 machine :).

Arne Kjetil
 

· Team Manager, Microsoft Support
Joined
·
33,785 Posts
Google this "Change data from vertical to horizontal to put into spread sheet" and you'll find a bunch of videos on the subject.
 

· Registered
Joined
·
2 Posts
Discussion Starter · #3 ·
Google this "Change data from vertical to horizontal to put into spread sheet" and you'll find a bunch of videos on the subject.
Inside a spreadsheet it's easy enough, was hoping to find a way to clean up the file before ..
It's not just what you see in the example, it's times 50++ ...( same pattern ).
Did it yesterday, but it takes time .....

Arne Kjetil
 
1 - 4 of 4 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top