Import .file values

I have a .file file with values from a mems accelerometer. I need to import the data into matlab, but i have trouble handling the format.

The first line of the file is this:

Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}

Any help?

Answer 1

[Voss]

unzip file.zip
ls *.file

file.file

str = fileread('file.file')

str = 
    'Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}
     Fri Apr  5 11:52:00 2024 52{'y': -0.07464344482421874, 'x': -0.7272808349609375, 'z': -10.553084448242187}'

C = regexp(str,'([^\r\n]+)\d{2}{''y'':(.+?), ''x'':(.+?), ''z'':(.+?)}','tokens');
C = vertcat(C{:})

C = 2x4 cell array
    {'Fri Apr  5 11:51:00 2024 '}    {' -0.06464344482421874'}    {' -0.6272808349609375'}    {' -10.453084448242187'}
    {'Fri Apr  5 11:52:00 2024 '}    {' -0.07464344482421874'}    {' -0.7272808349609375'}    {' -10.553084448242187'}

t = strtrim(C(:,1))

t = 2x1 cell array
    {'Fri Apr  5 11:51:00 2024'}
    {'Fri Apr  5 11:52:00 2024'}

yxz = str2double(C(:,2:end))

yxz = 2x3

-0.0646 -0.6273 -10.4531 -0.0746 -0.7273 -10.5531

<mw-icon class=""></mw-icon>

<mw-icon class=""></mw-icon>

[Ancalagon8]

Thank you for your answer, worked fine! If in the same directory i have multiple files (e.g. 100 files), is it possible to merge them into one file?

[Voss]

You're welcome!

unzip file.zip
ls *.file

file1.file  file2.file

directory = '.'; % directory where your files are
output_file = 'all_files.file'; % output file to write, containing contents of all files

files = dir(fullfile(directory,'*.file'));
files = fullfile({files.folder},{files.name});

L = [];
for ii = 1:numel(files)
    L = [L; readlines(files{ii})];
end
writelines(L,output_file);

% check the result for these two files
type(output_file)

Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}
Fri Apr  5 11:52:00 2024 52{'y': -0.07464344482421874, 'x': -0.7272808349609375, 'z': -10.553084448242187}
Fri Apr  5 11:52:00 2024 51{'y': -0.08464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}
Fri Apr  5 11:53:00 2024 52{'y': -0.09464344482421874, 'x': -0.7272808349609375, 'z': -10.553084448242187}

[Ancalagon8]

Thank you but i received Error using dlmread (line 147):

Mismatch between file and format character vector. Trouble reading 'Numeric' field from file (row number 1, field number 1). I tried saving the initial files as .csv and using csvread instead, but no result either.

[Voss]

Why don't you read the file(s) as I have done in my answer?

[Ancalagon8]

Because i received error Undefined function or variable 'readlines'.

I am using Matlab 2018b.

[Voss]

The code in my answer uses fileread, so I guess you are trying to run the code in my comment, which is for combining multiple files into one. Since you don't have readlines, try this instead:

unzip file.zip
ls *.file

file1.file  file2.file

directory = '.'; % directory where your files are
output_file = 'all_files.file'; % output file to write, containing contents of all files

files = dir(fullfile(directory,'*.file'));
files = fullfile({files.folder},{files.name});

N = numel(files);
C = cell(N,1);
for ii = 1:N
    C{ii} = regexprep(fileread(files{ii}),'\r?\n$','');
end
fid = fopen(output_file,'w');
fprintf(fid,'%s\n',strjoin(C,newline()));
fclose(fid);

% check the result for these two files
type(output_file)

Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}
Fri Apr  5 11:52:00 2024 52{'y': -0.07464344482421874, 'x': -0.7272808349609375, 'z': -10.553084448242187}
Fri Apr  5 11:52:00 2024 51{'y': -0.08464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}
Fri Apr  5 11:53:00 2024 52{'y': -0.09464344482421874, 'x': -0.7272808349609375, 'z': -10.553084448242187}

[Ancalagon8]

Worked thank you! One last question, in some files i have a second sensor so the first line instead of

Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187}

is

Fri Apr  5 11:51:00 2024 51{'y': -0.06464344482421874, 'x': -0.6272808349609375, 'z': -10.453084448242187} {'a': 0.7251908396946565, 'b': -2.2290076335877864, 'c': -0.7786259541984732}

How can i modify the line

C = regexp(str,'([^\r\n]+)\d{2}{''y'':(.+?), ''x'':(.+?), ''z'':(.+?)}','tokens');
?

[Voss]

C = regexp(str,'([^\r\n]+)\d{2}{''y'':(.+?), ''x'':(.+?), ''z'':(.+?)} {''a'':(.+?), ''b'':(.+?), ''c'':(.+?)}','tokens');