MATLAB: Sscanf reader format problems

sscanf format

Dear all,

I have to read to sscanf the following string: 18-11-20 22:25:00.000 BRUX XXX 2 0 0 0 4027896.395

I tried with the format specifier %02i-%02i-%021 %02i:%02i:%02.3f %s %s %i %i %i %i %.3f, but only the first int till 25 are correctly read. After that no other data are read. Any suggestion?

Thanks

Best Answer

>> str = '18-11-20 22:25:00.000 BRUX XXX  2  0  0  0  4027896.395';
>> sscanf(str,'%f-%f-%f%f:%f:%f %*s %*s%f%f%f%f%f')
ans =
        18.00000
        11.00000
        20.00000
        22.00000
        25.00000
         0.00000
         2.00000
         0.00000
         0.00000
         0.00000
   4027896.39500

Related Solutions

MATLAB: How to read a txt file having alphanumeric data and special characters. ? My text file is like this. I tried textread but could not get a result. any suggestion.

Here is an efficient solution using textscan. The test file is attached (you did not provide us with a sample file).

opt = {'Delimiter',' +*:','MultipleDelimsAsOne',true,'CollectOutput',true};
fmt = ['%*d%*d%*s%*d%*s',repmat('%f',1,6)];
[fid,msg] = fopen('test.txt','rt');
assert(fid>=3,msg)
C = textscan(fid,fmt,opt{:});
fclose(fid);

Which imports that last six columns of numeric data:

>> C{1}
ans =
     0.00000   0.00000   0.00000   0.11000   0.00000   0.88900
     0.00000   0.27200   0.00000   0.00600   0.00000   0.72200
     0.00000   0.03600   0.00000   0.00000   0.00100   0.96300
     0.00000   0.00000   0.00000   0.00000   0.00000   1.00000
     0.00000   0.00000   0.00000   0.00000   0.00000   1.00000
     0.00000   0.23800   0.36500   0.00900   0.03300   0.35500
     0.00000   0.00000   0.00000   0.00000   0.99900   0.00100
     0.00000   0.00000   0.00000   0.00000   0.00000   1.00000

MATLAB: How to convert datetime to datenum which date and time from different column

Try this

% clc;clear all; close all;
delim = ' '; % space delimited
% delim = '\t'; % tab delimited
% delim = ','; % comma delimited
%Input File
fid=fopen('E3D_KUAL_TPS.pos');
A = textscan(fid,'%s %s %f %f %f %f %f %f %f %f %f %f %f %f %f','HeaderLines',26); % read file;
date =string(A{1});
time =string(A{2});
str = date + ' ' + time;
dt = datetime(str,'InputFormat','yyyy/MM/dd HH:mm:ss.SSS');
dtnum = datenum(dt);

Best Answer

Related Solutions

MATLAB: How to read a txt file having alphanumeric data and special characters. ? My text file is like this. I tried textread but could not get a result. any suggestion.

MATLAB: How to convert datetime to datenum which date and time from different column

Related Question