MATLAB: How to import specific data from .f06 file in MATLAB

.f06tomatlab

I want to write a code which imports specific data from the .f06 file to plot graphs.

Best Answer

S = fileread('data.txt');
SS = regexprep(S, '^.*POINT ID.*?\n', '');
datacell = textscan(SS, '%f %s %f %f %*f %*f %*f %*f');
%the line after the last row happens to start with a number, and
%the %s is happy to eat the field after that, but then the %f for the
%third column fails to match. So the first two cells might be one
%entry longer than the third and fourth. Trim away excess
minlen = min(cellfun(@length, datacell));
datacell = cellfun(@(V) V(1:minlen, :), datacell, 'uniform', 0);
%everything is same length now
col1 = datacell{1};  %numeric


col2 = datacell{2};  %cell array of character vectors, probably single characters
col3 = datacell{3};  %numeric
col4 = datacell{4};  %numeric

Related Solutions

MATLAB: How to import a particular text file and plot.

By specifying a format string of '%s', you effectively asked textscan for a single output. But then you asked to read a string 5 times. Consequently output is a single cell which contains five things. Those five things are themselves cells, which contain the strings you want. (Confused?)

So to get the third header, do

header{1}{3}

Or, you could do

textscan(fid, '%s%s%s%s%s', 1, ...

In which case you will get back 5 cells. But then each of them contains a single cell (which contains a string)!

Unfortunately this is just the way textscan works. It makes sense for reading whole columns of data, but not so much for a header line.

You can always do what you were doing and add

header = header{1}

Or do it the other way I showed above and add

header = [header{:}]

Either way, then, header will be a 5-element cell array of the strings.

EDIT, attempting to clarify: textscan returns an n-element cell array, where n is the number of format specifiers in the format string. Each cell will contain the contents that were read from the file. If the contents were numeric, you'll just get a numeric array. But if they were strings, you'll get a cell array of strings. That's why you're ending up with cell arrays containing cell arrays.

MATLAB: Issue with data format when using textscan()

The format should be all lower case for duration.

%{hh:mm:ss}T

However, the data appears to be delimited as semicolon. You'd have more luck with readtable:

opts = detectImportOptions('D:\SI010118.txt')
opts = setvartype(opts,1,'datetime')
opts = setvaropts(opts,1,'InputFormat','dd.MM.uuuu HH:mm:ss')
readtable('D:\SI010118.txt',opts)

Best Answer

Related Solutions

MATLAB: How to import a particular text file and plot.

MATLAB: Issue with data format when using textscan()

Related Question