Read .txt file with header

Hello

I have a problem to read a text file into matlab with a header. The text file looks like this : http://web.gvdnet.dk/GVD002139/151.txt

i tried with this - and it works 99%

fid = fopen('151.txt','rt')
datacell = textscan(fid, '%s%s%f%f%f%f%f%f%s%s', 'HeaderLines',9);
fclose(fid);
A1 = mean(datacell{6})

The problems is that the result comes in a single column, but i want the mean of column 4,5,6 and 7 to be on a single row, so i can copy it into another textfile.

Hope anyone can help me. Thanks!

[John D'Errico]

When you delete your question, you insult those who spent the time to read your question and give a thoughtful answer to it. You decrease the odds that this person will bother to answer your next question. You harm the Answers site itself, because you leave a set of answers with no question, so nobody else an ever learn from your problem.

[Rena Berman]

(Answers Dev) Restored edit

Answer 1

[Oleg Komarov]

str  = urlread('http://web.gvdnet.dk/GVD002139/151.txt');
data = textscan(str, '%s%s%f%f%f%f%f%f%s%s', 'HeaderLines',9,'CollectOutput',1);
mean(data{2})

Answer 2

[Matt Kindig]

The 'textscan' function should do the trick.

doc textscan

Answer 3

[Walter Roberson]

A1 = mean([datacell{4:7}]);

You could also consider using the CollectOutputs option of textscan()