Clear Filters
Clear Filters

Extracting tables within a cell.

5 views (last 30 days)
Sai Gudlur
Sai Gudlur on 24 Feb 2024
Commented: Sai Gudlur on 29 Feb 2024
Hello,
Any suggestions or direction would be of great help.
In the attached code I am processing multiple files and each file has certain parameters and its respective values.
1) When I try to concatinate these values there are being stored as cells within a table and when try to run a loop to extract these elements and have them written out the loop isn't going past the first cell and only retriving it data.
2) I would want to have space of column between each files data. For Instance: First File produces 80X2 (Row,Col) data, I would like to know how to have space of a Column or two before Second File data is comprised.
Have tried Cell Function, For loop on the Cell itself but Brace Indexing it wouldn't work. now with this loop it is not moving forward.
Have attached a Few Sample files in txt format and Script.
I have updated the code and with the new for loop I am able to extract the first file but it doesn't go past that.
Thank You
[filelist,pathn] = uigetfile('*.txt','Please Select a Par Files', 'multiselect', 'on');
if isnumeric(filelist); error('no file selected');
end
filelist = cellstr(filelist);
%This take care of case where a single file is selected
filelist = fullfile(pathn, filelist);
for K = 1 : length(filelist)
filename = filelist{K};
Cal_Rev = extract(filelist,digitsPattern(5,8));
Data_in = readtable(filename, 'Delimiter',{',',';',' '});
Par_File_Parameters = Data_in.Var1(:);
Parameter_List = importdata('D:\GPP\GPP_Stuff\Parameter List.txt');
[C,ia,ib] = intersect(Par_File_Parameters,Parameter_List);
Common_PG = Data_in(ia,:);
PG_Name = Common_PG.Var1;
PG_Values = Common_PG.Var8;
TF_Economy = endsWith(PG_Name,'_00');
TF_Standard = endsWith(PG_Name,'_01');
TF_Performance = endsWith(PG_Name,'_02');
TF_Tanker = endsWith(PG_Name,'_03');
TF_Off_Road = endsWith(PG_Name,'_04');
TF_Economy_Table = Common_PG(TF_Economy,["Var1","Var8"]);
TF_Standard_Table = Common_PG(TF_Standard,["Var1","Var8"]);
TF_Performance_Table = Common_PG(TF_Performance,["Var1","Var8"]);
TF_Tanker_Table = Common_PG(TF_Tanker,["Var1","Var8"]);
TF_Off_Road_Table = Common_PG(TF_Off_Road,["Var1","Var8"]);
Complete_Table{K} = vertcat(TF_Economy_Table,TF_Standard_Table,TF_Performance_Table,TF_Tanker_Table,TF_Off_Road_Table);
end
for i = 1:length(Complete_Table)
New_Table = cell2table(Complete_Table{i}(:,:));
end
  2 Comments
Voss
Voss on 24 Feb 2024
Edited: Voss on 24 Feb 2024
Please upload the file "D:\GPP\GPP_Stuff\Parameter List.txt".
Sai Gudlur
Sai Gudlur on 24 Feb 2024
Voss,
Sorry about that it wasn't letting add files onto my questions so added my response to you.

Sign in to comment.

Accepted Answer

Voss
Voss on 25 Feb 2024
"I would want to have space of column between each files data"
See my additions at the end of the loop below for how you can do that.
(I also made modifications to get the code to run properly here in Answers, including replacing uigetfile and modifying the location of the parameter text file. You can ignore those changes, of course.)
% construct filelist from the relevant text files in the current directory,
% since I can't use uigetfile in the MATLAB Answers environment:
pathn = '.';
files = dir(fullfile(pathn,'*Dev*.txt'));
filelist = {files.name};
filelist = fullfile(pathn, filelist);
for K = 1 : length(filelist)
filename = filelist{K};
% Cal_Rev = extract(filelist,digitsPattern(5,8)); % Cal_Rev is unused
Data_in = readtable(filename, 'Delimiter',{',',';',' '});
Par_File_Parameters = Data_in.Var1(:);
% Parameter_List = importdata('D:\GPP\GPP_Stuff\Parameter List.txt');
Parameter_List = importdata('Parameter List.txt');
[C,ia,ib] = intersect(Par_File_Parameters,Parameter_List);
Common_PG = Data_in(ia,:);
PG_Name = Common_PG.Var1;
PG_Values = Common_PG.Var8;
TF_Economy = endsWith(PG_Name,'_00');
TF_Standard = endsWith(PG_Name,'_01');
TF_Performance = endsWith(PG_Name,'_02');
TF_Tanker = endsWith(PG_Name,'_03');
TF_Off_Road = endsWith(PG_Name,'_04');
TF_Economy_Table = Common_PG(TF_Economy,["Var1","Var8"]);
TF_Standard_Table = Common_PG(TF_Standard,["Var1","Var8"]);
TF_Performance_Table = Common_PG(TF_Performance,["Var1","Var8"]);
TF_Tanker_Table = Common_PG(TF_Tanker,["Var1","Var8"]);
TF_Off_Road_Table = Common_PG(TF_Off_Road,["Var1","Var8"]);
Complete_Table{K} = vertcat(TF_Economy_Table,TF_Standard_Table,TF_Performance_Table,TF_Tanker_Table,TF_Off_Road_Table);
% add a column of NaNs on the end (for a column of space when concatenating):
Complete_Table{K}{:,end+1} = NaN;
% make unique column names (names in all tables must be distinct before concatenating):
Complete_Table{K}.Properties.VariableNames = sprintf("Var%d_",K) + compose("%d",1:size(Complete_Table{K},2));
end
% concatenate:
New_Table = [Complete_Table{:}]
New_Table = 80×9 table
Var1_1 Var1_2 Var1_3 Var2_1 Var2_2 Var2_3 Var3_1 Var3_2 Var3_3 ____________________________________________ ______ ______ ____________________________________________ ______ ______ ____________________________________________ ______ ______ {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 NaN {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 NaN {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 NaN {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 NaN {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 NaN {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 NaN {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 NaN {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 NaN {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 NaN {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 NaN {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 NaN {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 NaN {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 NaN {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 NaN {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 NaN {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 NaN {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 NaN {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 NaN {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 NaN {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 NaN {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 NaN {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 NaN {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 NaN {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 NaN {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 NaN {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 NaN {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 NaN {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 NaN {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 NaN {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 NaN
  7 Comments
Voss
Voss on 28 Feb 2024
The trickiness there is that you can't mix data types within a table column. It works OK in this case because the first column of each table is a cell array, but if it was numeric you'd have to convert it to text first or put the version/Cal_Rev info in another column that is text or a cell array.
% [filelist,pathn] = uigetfile('*.txt','Please Select a Par Files', 'multiselect', 'on');
% if isnumeric(filelist); error('no file selected');
% end
% filelist = cellstr(filelist);
% This take care of case where a single file is selected
pathn = '.';
files = dir(fullfile(pathn,'*Dev*.txt'));
filelist = {files.name};
filelist = fullfile(pathn, filelist);
N = numel(filelist);
Cal_Rev = cell(1,N); % pre-allocate Cal_Rev
for K = 1:N
filename = filelist{K};
File_Details = importdata(filename);
Cal_Rev(K) = extract(File_Details.textdata{1,1},digitsPattern(5,8));
% extract digits after the underscore at the end of textdata{1}:
Version = regexp(File_Details.textdata{1},'_(\d+)$','tokens','once');
Version = 1+str2double(Version{1});
Data_in = readtable(filename, 'Delimiter',{',',';',' '});
Par_File_Parameters = Data_in.Var1(:);
% Parameter_List = importdata('D:\GPP\GPP_Stuff\Parameter List.txt');
% GPP_Names = importdata('D:\GPP\GPP_Stuff\GPP_NAME.txt');
Parameter_List = importdata('Parameter List.txt');
GPP_Names = importdata('GPP_NAME.txt');
[C,ia,ib] = intersect(Par_File_Parameters,Parameter_List);
Common_PG = Data_in(ia,:);
PG_Name = Common_PG.Var1;
PG_Values = Common_PG.Var8;
TF_Economy = endsWith(PG_Name,'_00');
TF_Standard = endsWith(PG_Name,'_01');
TF_Performance = endsWith(PG_Name,'_02');
TF_Tanker = endsWith(PG_Name,'_03');
TF_Off_Road = endsWith(PG_Name,'_04');
TF_Economy_Table = Common_PG(TF_Economy,["Var1","Var8"]);
TF_Standard_Table = Common_PG(TF_Standard,["Var1","Var8"]);
TF_Performance_Table = Common_PG(TF_Performance,["Var1","Var8"]);
TF_Tanker_Table = Common_PG(TF_Tanker,["Var1","Var8"]);
TF_Off_Road_Table = Common_PG(TF_Off_Road,["Var1","Var8"]);
TF_Economy_Table = addvars(TF_Economy_Table,GPP_Names,'Before',"Var1");
TF_Standard_Table = addvars(TF_Standard_Table,GPP_Names,'Before',"Var1");
TF_Performance_Table = addvars(TF_Performance_Table,GPP_Names,'Before','Var1');
TF_Tanker_Table = addvars(TF_Tanker_Table,GPP_Names,'Before','Var1');
TF_Off_Road_Table = addvars(TF_Off_Road_Table,GPP_Names,'Before','Var1');
Complete_Table{K} = vertcat(TF_Economy_Table,TF_Standard_Table,TF_Performance_Table,TF_Tanker_Table,TF_Off_Road_Table);
% make unique column names (names in all tables must be distinct before concatenating):
N = size(Complete_Table{K},2);
Complete_Table{K}.Properties.VariableNames = sprintf("Var%d_",K) + compose("%d",1:N);
% add two new rows at the top:
new_rows = { ...
sprintf('SW Label: %s',Cal_Rev{K}) '' NaN; ...
sprintf('Version: %d',Version) '' NaN; ...
};
Complete_Table{K} = [new_rows; Complete_Table{K}];
end
New_Table = [Complete_Table{:}];
disp(New_Table)
Var1_1 Var1_2 Var1_3 Var2_1 Var2_2 Var2_3 Var3_1 Var3_2 Var3_3 ____________________________________________________ ____________________________________________ ______ ____________________________________________________ ____________________________________________ ______ ____________________________________________________ ____________________________________________ ______ {'SW Label: 5516076' } {0×0 char } NaN {'SW Label: 5516076' } {0×0 char } NaN {'SW Label: 5516076' } {0×0 char } NaN {'Version: 2' } {0×0 char } NaN {'Version: 2' } {0×0 char } NaN {'Version: 2' } {0×0 char } NaN {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_00'} 1000 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_00' } 1125 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_00'} 1250 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_00' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_00' } 1100 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_00'} 875 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_00' } 1325 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_00'} 1400 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_00' } 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_00'} 1450 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_00' } 1275 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_00' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_00' } 1250 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_00' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_00' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_00' } 1725 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_01'} 1085 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_01'} 1125 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_01'} 1175 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_01' } 1000 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_01' } 975 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_01' } 1100 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_01'} 1050 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_01'} 1200 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_01'} 1200 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_01' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_01' } 1000 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_01' } 1050 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_01' } 1225 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_01' } 1200 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_01' } 1200 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_01'} 850 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_01'} 925 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_01'} 925 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_01' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_01' } 1400 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_01' } 1325 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_01'} 1550 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_01'} 1600 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_01'} 1625 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_01' } 1500 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_01' } 1800 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_01' } 1950 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_01'} 1525 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_01'} 1700 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_01'} 1725 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_01' } 1325 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_01' } 1350 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_01' } 1225 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_01' } 1350 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_01' } 1450 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_01' } 1450 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_01' } 1350 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_01' } 1450 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_01' } 1500 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_01' } 1700 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_01' } 1925 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_01' } 1950 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_01' } 1750 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_01' } 1925 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_01' } 1950 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_01' } 1800 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_01' } 1925 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_01' } 1950 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_02'} 1000 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_02'} 1250 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_02'} 1250 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_02' } 1125 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_02' } 1150 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_02' } 1150 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_02'} 1250 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_02'} 1300 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_02'} 1300 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_02' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_02' } 1050 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_02' } 1050 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_02' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_02' } 1225 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_02' } 1250 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_02'} 875 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_02'} 975 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_02'} 975 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_02' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_02' } 1500 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_02' } 1475 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_02'} 1400 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_02'} 1675 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_02'} 1800 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_02' } 1450 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_02' } 1850 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_02' } 2000 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_02'} 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_02'} 1800 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_02'} 1950 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_02' } 1275 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_02' } 1350 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_02' } 1350 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_02' } 1250 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_02' } 1550 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_02' } 1475 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_02' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_02' } 1500 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_02' } 1625 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_02' } 1725 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_02' } 1975 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_02' } 1975 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_02' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_02' } 1975 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_02' } 1975 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_02' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_02' } 1975 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_02' } 1975 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_03'} 1000 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_03'} 1150 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_03'} 1175 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_03' } 1125 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_03' } 975 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_03' } 1100 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_03'} 1250 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_03'} 1200 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_03'} 1200 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_03' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_03' } 900 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_03' } 1050 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_03' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_03' } 1150 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_03' } 1200 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_03'} 875 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_03'} 925 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_03'} 925 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_03' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_03' } 1400 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_03' } 1325 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_03'} 1400 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_03'} 1650 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_03'} 1650 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_03' } 1450 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_03' } 1800 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_03' } 1850 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_03'} 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_03'} 1700 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_03'} 1750 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_03' } 1275 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_03' } 1500 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_03' } 1400 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_03' } 1250 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_03' } 1450 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_03' } 1500 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_03' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_03' } 1400 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_03' } 1525 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_03' } 1725 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_03' } 1925 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_03' } 1825 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_03' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_03' } 1925 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_03' } 1875 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_03' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_03' } 1925 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_03' } 1950 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_04'} 1000 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_04'} 1175 {'100% Throttle Upshift, Flat – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDemandCruiseGear_04'} 1175 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_04' } 1025 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_04' } 1025 {'100% Throttle Upshift, Flat – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDemandLowGear_04' } 1025 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_04'} 1075 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_04'} 1200 {'100% Throttle Upshift, Flat – Cruise Gears' } {'C_PG_PtmGs_ShPtDnHighDemandMiddleGear_04'} 1200 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_04' } 1100 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_04' } 850 {'100% Throttle Upshift Uphill – Low Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevLowGr_04' } 850 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_04' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_04' } 1100 {'100% Throttle Upshift Uphill – Middle Gears' } {'C_PG_PtmGs_ShPtDnHighDmdHighSevMidGr_04' } 1100 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_04'} 875 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_04'} 1050 {'100% Throttle Upshift Uphill – Cruise Gears' } {'C_PG_PtmGs_ShPtDnLowDemandLowSeverity_04'} 1050 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_04' } 1325 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_04' } 1300 {'Low Throttle Upshift - Low Gears' } {'C_PG_PtmGs_ShPtDnMaxPerformance_04' } 1300 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_04'} 1400 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_04'} 1725 {'Low Throttle Upshift - Middle Gears' } {'C_PG_PtmGs_ShPtUpHighDemandCruiseGear_04'} 1725 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_04' } 1450 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_04' } 1950 {'Low Throttle Upshift - High Gears' } {'C_PG_PtmGs_ShPtUpHighDemandLowGear_04' } 1950 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_04'} 1450 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_04'} 1850 {'100% Throttle Downshift points - Low Gears' } {'C_PG_PtmGs_ShPtUpHighDemandMiddleGear_04'} 1850 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_04' } 1525 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_04' } 1700 {'100% Throttle Downshift points - MiddleGears' } {'C_PG_PtmGs_ShPtUpLowDemandLowGear_04' } 1700 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_04' } 1250 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_04' } 1650 {'100% Throttle Downshift points - Cruise Gears' } {'C_PG_PtmGs_ShPtUpLowDemandMidGear_04' } 1650 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_04' } 1250 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_04' } 1600 {'100% High Grade Downshift Points - Low Gears' } {'C_PG_PtmGs_ShPtUpLowDemand_04' } 1600 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_04' } 1725 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_04' } 1925 {'100% High Grade Downshift Points - Middle Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfLowGear_04' } 1925 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_04' } 1725 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_04' } 1900 {'100% High Grade Downshift Points - Cruise Gears'} {'C_PG_PtmGs_ShPtUpMaxPerfMidGear_04' } 1900 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_04' } 1725 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_04' } 1900 {'Low Throttle Downshift points - All Gears' } {'C_PG_PtmGs_ShPtUpMaxPerformance_04' } 1900
Sai Gudlur
Sai Gudlur on 29 Feb 2024
Thank you Voss, I see what you did you first defined the string and later concatinated. thanks a lot have a great day.

Sign in to comment.

More Answers (1)

Matt J
Matt J on 25 Feb 2024
Edited: Matt J on 25 Feb 2024
when try to run a loop to extract these elements and have them written out the loop isn't going past the first cell and only retriving it data.
You have 2 loops in your code, so we don't know which loop you're talking about. The first loop seems to be progressing past the first file. I obtain a cell entry Complete_Table{k} for all 3 files, and they are not identical.
The final loop throws an error, but the true intention of the loop isn't clear. Complete_Table{i}(:,:) is not a cell array, so it makes no sense to be applying cell2table.
  2 Comments
Sai Gudlur
Sai Gudlur on 25 Feb 2024
Yes u are correct i was trying everything that I can. actually if just index like below it is retrieving only one (first file) of the multiple files i have turned in as input.
for i = 1:length(Complete_Table)
New_Table = Complete_Table{i};
end
Matt J
Matt J on 25 Feb 2024
New_Table is not indexed. Did you mean to have,
New_Table{i} = Complete_Table{i};
But then what is the purpose? It will just copy Complete_Table to a different variable.

Sign in to comment.

Categories

Find more on Language Support in Help Center and File Exchange

Products


Release

R2022b

Community Treasure Hunt

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

Start Hunting!