looping throwing errors, how can I avoid them?

조회 수: 1 (최근 30일)
Teshan Rezel
Teshan Rezel . 2021년 1월 28일
댓글: Teshan Rezel . 2021년 6월 2일
Hi folks,
I have a couple of questions about the following code. I get an error when doing the k-loop which states "Reference to non-existent field 'x'".
I am trying to populate a table for each "testPiece" with all the measurements, and then write them to an excel file. The problem is that some measurements might be missing from the 1290 files this loops through. Is there a way around this?
I essentially want to, for each testpiece, go through all the xml files and populate a table with each measurement. If the measurement is missing in a particular file, I want it to write "NA" or "-" instead. I'm not sure where I'm going wrong, only that I am!
Any help would be greatly appreciated.
startingFolder = pwd;
fprintf('Select the directory containing the Images and Auto analysis \n \n');
RawImages = uigetdir(startingFolder); %Creating the variable from the user selection
addpath(RawImages); %Ensuring matlab will follow the path
files = dir([RawImages '\AutoAnalysis\*.xml']);
numOfFiles = numel(files); %Counting number of files in the folder for looping purposes
Settings = xml_read(fullfile([RawImages '\settings.xml'])); %reading XML file
NumOfSamples = Settings.numberOfTestPieces;
headings = {'Time','Temperature','Height','Area','Circumference', 'Shape Factor', 'Tip Radius', 'Base Width', 'Max Width', 'Height:Base Width Ratio', 'Height:Max Width Ratio', 'Bse Centre X', 'Base Centre Y', 'LHS Difference', 'RHS Difference'};
objectRangeEnd = strcat('O', num2str(numOfFiles));
objectRange = strcat('A2:', objectRangeEnd);
numMaxIndices = 13;
structIndices = {'height', 'area', 'circumference', 'shapeFactor', 'tipRadius', 'baseWidth', 'maxWidth', 'hBwRatio', 'hMwRatio', 'baseCentreX', 'baseCentreY', 'lhsDiff', 'rhsDiff'};
for i = 1:NumOfSamples %Getting the manually named test pieces from the settings
TestPieceName = Settings.testPiece.TestPieceStorage.name; %Creating a name variable to use when making file and folder names
Sample = ['Test Piece ' num2str(i) '-' TestPieceName];
TestPiece = zeros(numOfFiles,3); %Making an array to store the variables
testPieceIdentifier = strcat('testPiece', num2str(i));
for j = 1:numOfFiles %Grabbing the time and file data from the save file name
flds = {'date','bytes','isdir','datenum'}; %Reading time and temp from file
A = rmfield(files,flds); %Remove the file information that is unnecessary
codes = struct2cell(A); %Reduces the structure to only the fields required
codes = codes'; %Converts the labels in A to the format required
new = strsplit(char(codes(j)),'.'); % To remove the file type
new2 = strsplit(char(new(1)),'-'); % Splits the experimental conditions
time = str2double(new2(2));
alpha = new2(3);
alpha = char(alpha);
alpha(1) = [];
temp = str2double(alpha);
TestPiece(j,1) = time;
TestPiece(j,2) = temp;
file = fullfile([ RawImages '\AutoAnalysis\' files(j).name]); % Creating the k-th file name
DataSet = xml_read(file); % read XML files
%Indexing Height, Area, and Circumference etc.
for k = 1 : numMaxIndices
if isfield(DataSet.(testPieceIdentifier).testPieceMeasurements, (structIndices{k})) == 1
initialMeasurement = TestPiece(1, (k+2));
if initialMeasurement > 0
TestPiece(j, (k+2)) = DataSet.(testPieceIdentifier).testPieceMeasurements.(structIndices{k})/initialMeasurement;
TestPiece(j, (k+2)) = DataSet.(testPieceIdentifier).testPieceMeasurements.(structIndices{k});
TestPiece(j, (k+2)) == 'N/A';
sampleDirectory = fullfile(RawImages); %file creation
filename = fullfile(sampleDirectory, ['Results.xls']); %Creating the filename to put the excel file in the appropriate folder
writecell(headings, filename, 'Sheet', Sample, 'Range', 'A1:O1');
writematrix(TestPiece, filename, 'Sheet', Sample, 'Range', objectRange);
  댓글 수: 4
Teshan Rezel
Teshan Rezel 2021년 1월 28일
hi @Stephen Cobeldick, The filenames themselves do not contain periods in them.

댓글을 달려면 로그인하십시오.

채택된 답변

Jan 2021년 1월 28일
편집: Jan 님. 2021년 1월 28일
[~,new] = fileparts(files(j).name);
% Now "new" is a CHAR vector.
new2 = strsplit(char(new(1)),'-'); % Splits the experimental conditions
% This splits the first character of the CHAR vector new.
% Then "new2" has 1 CHAR only created by splitting a single CHAR
time = str2double(new2(2));
% new2 has 1 element only...
[~,new] = fileparts(files(j).name);
new2 = strsplit(new, '-'); % Splits the experimental conditions
time = str2double(new{2});
  댓글 수: 3
Teshan Rezel
Teshan Rezel 2021년 6월 2일
Hi @Jan, I think I solved this issue earlier but can't remember how...apologies!

댓글을 달려면 로그인하십시오.

추가 답변 (0개)


Help CenterFile Exchange에서 Matrix Indexing에 대해 자세히 알아보기




Community Treasure Hunt

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

Start Hunting!

Translated by