transform column of inequality data??

Hello, I have a column of inequality data (see attached) that I am trying to transform into 3 new columns but I don't know the right syntax/formula. The first column containing the number values for all of the less than inequality data, the second column containing all of the data points that were reported as a number, and the third column containing all of the number values for the data points that were reported as greater than. I was thinking it would be some combination of using logicals and filter operators but I have been unsuccessful. What is the appropriate code to do this? Thank you for any help you can give me

Example:

Dan

[darova]

Can you show yuor attempts? What about something like that

out3 = data > 32;

Answer 1

[Prabhan Purwar]

Hi,

Kindly try using the following code:

clc
close all
clear
var=readcell('data_example (3)');  %Load data
tbl{1,1}=var{1,2};
tbl{1,2}=var{1,3};
tbl{1,3}=var{1,4};
for i=2:13
a=var{i,1};
tfg=strcmp(a(1),'>');           %String compare
tfs=strcmp(a(1),'<');
if(tfg==1) tbl{i,3}=a(2:end);
end
if(tfs==1) tbl{i,1}=a(2:end);
end
if (tfs==0 && tfg==0 ) tbl{i,2}=a(1:end);
end
tfs=0;tfg=0;
end

Output: