creating an array from a txt file

sorry if this is a silly question, but I have just started to use matlab.

I am trying to create an array using the txt file 'ifng.txt' however I want to remove the first row as it is just headers, this is what I have so far

function output = IFNG2016 
fid= fopen('ifng.txt','r');
A = textscan(fid, '%f', 'HeaderLines', 1)

however it just prints

A= [0x1 Double]

any assistance would be appreciated.

Thanks

[Thorsten]

It would be helpful to upload the file ifng.txt.

[Andreas Donauer]

One of many posibilities:

% open the file
fid = fopen('ifng.txt');  % could check if fid is nonempty here  
% read first line
tline = fgets(fid); 
index = 0;
% if char (not end of file), keep reading
while ischar(tline) 
  index = index+1;
      txt{index} = tline(1:end-1); % store line in a cell-array-of-strings
      tline = fgets(fid);
end
% close file
fclose(fid);
% re-format starting from line 2
script = sprintf('%s',txt{2:end});
% replace line feeds (windows)
script(script==13) = sprintf('\n');
% finally, print what you've been reading in command line:
fprintf(script);

[C Mck]

i have edited the question and included the txt file

[Andreas Donauer]

Have you tried what I posted? If this works for you, please check the question solved.

[Star Strider]

@Andreas Donauer —

Post your Comment here as an Answer.

[C Mck]

@Andreas Donauer

thanks it works

Answer 1

[Guillaume]

The reason your textscan does not work is simply because the first column (the probe name) is not made of numbers so the '%f' format fails on that. This would work (and is much better than the whole file parsing suggested by Andreas):

fid= fopen('ifng.txt','r');
A = textscan(fid, ['%s', repmat('%f', 1 , 25)], 'HeaderLines', 1);
Anumbers = [A{2:end}];

Note that in the header, your file uses a combination of tabs and spaces as the delimiter. If you actually fixed that, then reading the file would be as simple as:

t = readtable('ifng.txt', 'Delimiter', 'tab');  %or 'space' if you replace the tabs by spaces

As a bonus you get the header read properly as variable names, so you don't even need to skip it.

[C Mck]

this didn't work, when i try to print to the screen nothing aooears

[Guillaume]

As said, the readtable will only work if you fix the mixed tab/space issue in the file.

The other way works fine with the file you provided (after I fixed the missing ] that would have resulted in a syntax error if you tried it).

[C Mck]

thanks, this works now, I was putting the missing ] i the wrong place. at the minute its is displaying 1.0e+05* and then the array, do you know how I can get it to display the full number as displayed in the txt file, I have tried 'format long' but that isnt working Thanks

[Guillaume]

I tend to use format longg or format shortg, but that is completely unrelated to your original question (which I believe is solved, so you should accept the answer).