On a project, I copy the contents of a table, and then I would like to calculate the mean of different columns. The table I copy always has the same number of coloumns but the number of rows may wary (see picture for an example of two different tables):
My goal is to be able to calculate the mean of the last three coloumns for each "Kanal" (see the red circles in picture):
My first step has been to use StrSplit to separate the string into an array but after that, I´m unsure of what to do.
Code: Select all
lines := StrSplit(clipboard, "`n")
columns := []
for index, value in lines
columns.Insert(StrSplit(value, "`t"))
The table example is attached as a txt file
Any help is greatly appreciated.