Changing from char variable to another input

2019 10 8
1 个回答
回答已采纳
更新时间：2019 10 9
2 次查看（30 天）

0 个投票

Forgive my naivity on this one. How can I change a 1x47004 char to a matrix which has letters/words in some cells and numbers in the rest? At present I have the following 6x6 cell.
1x47004 char [] [] [] [] []
1x45843 char [] [] [] [] []
1x46992 char [] [] [] [] []
1x46432 char [] [] [] [] []
1x46459 char [] [] [] [] []
1x48191 char [] [] [] [] []

5 个评论
显示 3更早的评论 隐藏 3更早的评论

dpb
dpb 2019-10-8
Attach a .mat file with the cell content or show a short section of what you have and what you're trying to get...
Jake Bowd
Jake Bowd 2019-10-8
Thanks for the reply.
I am using the following to load in .mot files, for which I then want to work out certain metrics such as maximum/minimum and range of motion. But when I use the following code the inputs are not in rows/column format.
%% Load in Session Trials
testfiledir = 'D:\Leuven_Visit\Workflow\Modelling\simL\Pre_32L\MFD_opt\Tibia\';
matfiles = dir(fullfile(testfiledir, '*.mot')); %% Loads all .mot files for the above directory
nfiles = length(matfiles);
data = cell(nfiles);
for i = 1 : nfiles
fid = fopen( fullfile(testfiledir, matfiles(i).name) );
data{i} = fscanf(fid,'%c');
fclose(fid);
end
Jake Bowd
Jake Bowd 2019-10-8
Apologies, I didn't attach the .mat file; please see attached.
dpb
dpb 2019-10-8
OK, you're trying to read some custom format it appears.
Attach a section of one of the underlying .mot files so we can see what you're actually starting from.
The conversion from the .mat file is trying to fixup after a mess; better by far to avoid the mess in the first place instead.
Image Analyst
Image Analyst 2019-10-8
What is a .mot file? Is it the same as a .mat file? Did you create it with the save() function?

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Joe Vinciguerra
Joe Vinciguerra 2019-10-8
编辑：Joe Vinciguerra 2019-10-8

2 个投票

Your *.mot files are coming in as one very long character array.
You can either try to parse it character-by-character into a cell array, or table, or structure, etc... OR import your data differently.
Try using the readtable function
https://www.mathworks.com/help/matlab/ref/readtable.html
Try this:
for i = 1 : nfiles
data{i} = readtable(fullfile(testfiledir, matfiles(i).name));
end

10 个评论
显示 8更早的评论 隐藏 8更早的评论

Jake Bowd
Jake Bowd 2019-10-8
Hi Joe,
Thanks for the support. When I try the readtable an error arises stating its undectable?
Guillaume
Guillaume 2019-10-8
Please attach one of the files you're trying to parse. readtable can always be given hints on how to parse the file.
Jake Bowd
Jake Bowd 2019-10-8
When I try and send a file to you, I get the following message:
Cannot attach this file because:
  • File format is unsupported for files:Pre_32L_NLwalk7_norm_mfd.mot,Pre_32L_NLwalk7_norm_mfd_tf.prs,Pre_32L_NLwalk7_norm_mfd_tf.prx,Pre_32L_NLwalk7_norm_mfd_thickness_tf.prx. Use any of these formats:.bmp, .csv, .fig, .gif, .jpg, .jpeg, .m, .mat, .mdl, .mlx, .slx, .sbproj, .pdf, .png, .txt, .xls, .xlsx, .zip
Is there another way I can send it to you?
Thank you so much for your help and assistance on this. It is very much appreciated.
Kind regards,
Joe Vinciguerra
Joe Vinciguerra 2019-10-8
either rename the extension from .mot to .txt or one of the other options. Or put it in a .zip file.
Jake Bowd
Jake Bowd 2019-10-8
Please see attached for the different types I wish to load in.
Joe Vinciguerra
Joe Vinciguerra 2019-10-8
编辑：Joe Vinciguerra 2019-10-8
I was able to read them all in okay after changing the extensions from .mot (et.al.) to .csv
the .mot file came in just fine after that. However, the other files need extra massaging on the deliminator settings for the readtable function. You could also play around with csvread and the other similar functions to see which works better for you.
https://www.mathworks.com/help/matlab/import_export/ways-to-import-text-files.html
https://www.mathworks.com/help/matlab/ref/textscan.html
https://www.mathworks.com/help/matlab/ref/detectimportoptions.html
Guillaume
Guillaume 2019-10-8
You don't need to change the extension for readtable to parse the files properly. You just need to specify the 'FileType' as 'text' in the readtable call. 'text' is automatically assumed for extensions .txt, .dat, and .csv.
Guillaume
Guillaume 2019-10-8
The .mot file can indeed easily be read by 'readtable':
mot = readtable('Pre_32L_NLwalk7_norm_mfd.prf', 'FileType', 'text')
The other files, since the number of values per line varies, cannot be read with readtable. A dedicated parser will have to be written.
Jake Bowd
Jake Bowd 2019-10-8
Brilliant, thank you so much for the help getting the .mot files in!
Are you able to direct me to how to create/write dedicated parsers for the other files?
(can you tell that I am new to Matlab?! :) )
Thank you so much
Jake Bowd
Jake Bowd 2019-10-9
Guillaume, how to I notify that I am happy with your answer and mark it as 'answered'?
P.s. if you are able to direct me to how to create/write dedicated parsers for the other files that would be really useful.
Cheers

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息

产品

版本

R2019b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by