Extract two frist numbers form a column

Hi,

I have a column with 400 000 variables that look something like this:

68.092

67.011

76.949

etc.

I would like to extract the two first numbers into a new column such that I get a column that looks like this:

68

67

76

If it matters, the column is categorical.

Answer 1

[KSSV]

A = [68.092
67.011
76.949] ; 

integ = floor(A);
fract = A-integ;

[Amina Ag]

Thank you for your reply! Unfortunately the floor function only returns me NaNs.

Answer 2

[EmirBeg]

If it's categorical you need to convert it to doubles first.

A = categorical([68.092; 67.011; 76.949]); %Creating your categorical Array.

B = double(string(A)); %Converting and shortening it.
B = floor(B);

B =

68

67

76

Hope it works. Pozdrav.

[Amina Ag]

Hi Emir,

Thank you for your reply. Converting to double only returnes me NaNs and therefore the floor function does not work either. I managed to do it in another program though but highly appreciate your time and response.

Hvala puno! Pozdrav.