extracting four words from a file name and placing them in four cells at the start of each row of a data table.

Question

WENDILYN GUIDOTTI 2022-11-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1855793-extracting-four-words-from-a-file-name-and-placing-them-in-four-cells-at-the-start-of-each-row-of-a

评论： WENDILYN GUIDOTTI 2022-11-23

I am trying to creat a GUI that will process files for me and create an excel sheet. I want to take four words from my filename and place them in four cells at the start of each row of data in the file. Below is the code I am working on :

cd = app.selectedPath;

[A] = my function string ;

Aa = rmfield(A,'field_');

Ab = struct2table(Aa);

filePattern = fullfile(cd,'A_*):

fileList = dir(filePattern);

B = strsplit(fileList.name,'_');

Bb = N([1 11 12 13]);

*** following this is a loop that goes through the file pattern and processes all similar files and saves out an excel sheet with the original file name. Bb are the four cells I want to add to Ab. Ab will always be various lengths.