I need some Help with data formatting in file .txt

1 view (last 30 days)
I have a file with 22 columns and 745 lines. The first line is just a header. I need to delete the first column. How can I do that? The header can be delete too.
the data follow the format below.
Thanks
Hora No1 No2 No3 No4 No5 No6 No7 .... No21
00:00:00 18.54 18.69 18.83 18.95 19.05 19.15 19.73
00:00:10 .. ... ... ... ... ... ...
...
...

Accepted Answer

Roy Kadesh
Roy Kadesh on 14 Feb 2018
If you have read your file to a table, you can just remove the variable. If you read your file as a char matrix, you can just remove the first 9 element (with A(:,1:9='';) and remove the top row (with A(1,:)='';).
  2 Comments
Bruno Souza
Bruno Souza on 15 Feb 2018
Dear Roy, I don't know how to read the file like a table or matrix...
Roy Kadesh
Roy Kadesh on 16 Feb 2018
Did you find a solution? If not, the code below should help:
fid=fopen(filename,'rt');
data=textscan(fid,'%s','Delimiter','\n');
fclose(fid);

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!