Extract numeric value from a cell in a table.

Question

Jorge Alberto Fuentes Casillas 2016-12-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317172-extract-numeric-value-from-a-cell-in-a-table

评论： Elton Martinez 2023-6-9

采纳的回答： Jorge Alberto Fuentes Casillas

在 MATLAB Online 中打开

Hello to all!

I want to extract the numeric values of a mixed data that I have in a cell of an array. This is what I have done:

T = readtable('file.dat','Format','%s'); %Which creates a table with 1 column and 525606 rows.

latitude = T{1,1} %which creates an array with the next output:

latitude =

'12.967 [deg N]'

only one char value.

What I want to do now is to get only the numerical value from that array, I've tried char2string and sscanf but it only prompts errors and no conversion. Please help :) I know that it seems to be a simple procedure but I'm stuck here.

Thanks in advance!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jorge Alberto Fuentes Casillas 2016-12-16

在 MATLAB Online 中打开

Hello. Thanks for the reply. Apparently that code prompts this error:

>> latitude = T{1,1}

latitude =

'12.967 [deg N]'

>> C = strsplit(T{1,1}) Error using strsplit (line 76) First input must be a string.

>>

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jorge Alberto Fuentes Casillas 2016-12-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317172-extract-numeric-value-from-a-cell-in-a-table#answer_247517

Thanks for your support. This is another way to solve it and that I used in the version 2014b:

coordinates = readtable('Bangalore-20161215_min.dat','Format','%s');

%% We split in this part the tables' content that we need (latitude, longitude, time, etc).

expression = ' '; %Helps to divide the cell everytime we find a space. splitStr_lat = regexp(coordinates{1,1},expression,'split'); %we split the string in one row with 3 columns or cells. Every time that the code finds a ' ' (space) character, it will split the character and put it in one cell.

num_lat = splitStr_lat{1,1};%variable that has the numerical value of latitude. latitude = cell2mat(num_lat(1,1)); %Convert from cell to numerical value.

%% We do the same for longitude. splitStr_long = regexp(coordinates{2,1},expression,'split'); %now we get the longitude in the row 2 column 1. num_long = splitStr_long{1,1}; longitude = cell2mat(num_long(1,1));

I will try with your code, Star Strider.

Thanks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

José-Luis 2016-12-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317172-extract-numeric-value-from-a-cell-in-a-table#answer_247474

在 MATLAB Online 中打开

 C = strsplit(T{1,1})
 your_val = str2num(C{1});

7 个评论
显示 5更早的评论隐藏 5更早的评论

Jorge Alberto Fuentes Casillas 2016-12-16

The same error:

C = strsplit(T{1}) You can not subscript a table using only one subscript. Table subscripting requires both row and variable subscripts.

Elton Martinez 2023-6-9

The following is missing something T{1,1}{1} should work, for future reference

请先登录，再进行评论。