Hi @Vlatko,
I understand that you have two tables “Table_A” and “Table_B” and both the tables contain four columns, each column having a unique variable name. Given that the variable names in the two columns (one from each table) match between positions 5 and 10, the objective is to generate four new tables. These tables will specifically contain two columns each, where the variable names match.
I am attaching the code which creates four new tables consisting of two columns where the variable names match: -
names5 = Table_A.Properties.VariableNames;
names6 = Table_B.Properties.VariableNames;
matchVals = {'1234', '5678', '9101', '1123'};
numTables = numel(matchVals);
tableNames_ = cell(numTables, 1);
for k = 1:numel(matchVals)
pattern = matchVals{k};
startIdx = 5; % Starting index
endIdx = 10; % Ending index
idl5 = cellfun(@(x) contains(x(startIdx:endIdx), pattern), names5);
idl6 = cellfun(@(x) contains(x(startIdx:endIdx), pattern), names6);
eval(['Summary', matchVals{k}, ' = [Table_A(:, idl5) Table_B(:, idl6)];']);
tableNames_{k} = ['Summary', matchVals{k}];
end
You can also refer to the MATLAB documentation for the function "contains" to obtain more information on its usage and syntax. The link is provided below:
I hope this helps!
