Setting min and max values

Hi there !

I have a csv imported in an SQL table, 3 columns have numeric data's such as min, max and fixed value, I wrote a script wich gather min and max value from all 3 column and display in an edit text boxes.

How can a set the column format for csv or SQL so when i import the table in a uitable in gui where the row is empty to show NaN, otherwise the min value showned in a min edit text box is 0. In this case should be 0.05 based on capture attached.

data = cell2table(data);
max_col5 = max(data{:,5});
max_col6 = max(data{:,6});
max_col7 = max(data{:,7});
max_col567 = max([max_col5; max_col6; max_col7]); 
min_col5 = min(data{:,5});
min_col6 = min(data{:,6});
min_col7 = min(data{:,7});
min_col567 = min([min_col5; min_col6; min_col7]);


set(handles.edit13,'string',min_col567);%MIN 1
set(handles.edit14,'string',max_col567);%MAX 1

Thanks

Answer 1

[Matt J]

data = cell2table(data);

max_col567 = max(data{:,5:7},[],'all'); 
min_col567 = min(data{:,5:7},[],'all'); 

fmt=fillmissing(string(A),'constant',"NaN");

set(handles.edit13,'string',fmt( min_col567 ));%MIN 1
set(handles.edit14,'string',fmt( max_col567) );%MAX 1

[Cristian Martin]

Thanks!