MATLAB Answers

How to read out a textfile from a specific line

70 views (last 30 days)
Hello Community,
I have a probably rather easy problem (at least for you guys). I have a textfile (attached) that is structured in lines and collums. And I want two specific collumns out of that file (Plasma_voltage_actual and Plasma_current_actual). Problem is that the first part of that text file has a different structure (just lines). So first I need to delete all the unnecessary stuff before the collumns start (actually no idea how to do that). That would be everything up to the line with which says "DATA RECORDINGS". What I want in the end is a Matrix with the headlines (Time Pressure Pres_set ...) and then the values for each collumn. Can you help me with that? The goal in the end is to take those two collumns and calculate the mean of them. But I guess I can (hopefully) figure that out on my own.
Thank you very much :)


Sign in to comment.

Accepted Answer

Stephen Cobeldick
Stephen Cobeldick on 23 Jan 2019
Edited: Stephen Cobeldick on 23 Jan 2019
opt = {'Delimiter','\t', 'CollectOutput',true};
[fid,msg] = fopen('pG8.txt','rt');
% Ignore lines until "DATA RECORDING":
str = '';
while ~strcmpi(str,'DATA RECORDING:') && ~feof(fid)
str = fgetl(fid);
% Read table header:
str = fgetl(fid);
hdr = regexp(str,'\t','split');
% Create format string:
fmt = repmat({'%*s'},1,numel(hdr));
idx = ismember(hdr,{'Plasma_voltage_actual(V)','Plasma_current_actual(mA)'})
fmt(idx) = {'%f'};
% Read table:
tmp = textscan(fid,[fmt{:}],opt{:});
out = tmp{1}
Which gives:
>> size(out) % nice big matrix of data:
ans =
3208 2
>> out(1:10,:) % not so interesting:
ans =
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Lets try plotting it
X = 1:size(out,1);


Heidi Mäkitalo
Heidi Mäkitalo on 12 Jun 2019
Sorry if this is something that should be easily done, but how should I modify this code if I want the "out"-matrix to contain not only two columns from the file but all of them? (Asking because I have a similar problem but want to keep and analyze all of the columns from the file.)
Stephen Cobeldick
Stephen Cobeldick on 13 Jun 2019
@Heidi Mäkitalo: simply define the format string to read all columns, e.g.
fmt = repmat('%f',1,numel(hdr));
You will have to select an appropriate column format specifier for your data.

Sign in to comment.

More Answers (1)

Jeremy Hughes
Jeremy Hughes on 23 Jan 2019
You might try READTABLE with import options:
>> opts = detectImportOptions(filename)
% Check that the number of header lines looks right
>> opts.SelectedVariableNames = {... the names you want to read ...}
>> T = readtable(filename,opts)


Sign in to comment.

Community Treasure Hunt

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

Start Hunting!