[Drollnor]

I got an output file from a testing machine that I need to clean up a bit before importing into some spreadsheet..

"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

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

 

[Corday]

Google this "Change data from vertical to horizontal to put into spread sheet" and you'll find a bunch of videos on the subject.

 

[Drollnor]

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

 

[johnwill]

I'd be looking at simple script languages to manipulate the text file before you import it. I've seen some similar processing done in Python.