extract numeric values from strings in xls files?

Question

Dimitris 2011-11-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21680-extract-numeric-values-from-strings-in-xls-files

Hi,

I have an xls file with 10 columns. The columns are full of string and inside the strings there are some numeric values that I need to extract and put in a new column. I was thinking to do something like this:

load doc.txt  %to load the file in txt format
  for i=1:total lines of txt
     read each line
      take numeric values
       put in table
end

I don't even know if any from above is possible in matlab. Is it possible to read strings and from them extract the numeric values?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2011-11-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21680-extract-numeric-values-from-strings-in-xls-files#answer_28560

You can use regexp() and str2double()

Note: if the values are floating point numbers that might be in exponential format, then it is fairly difficult to construct a correct regexp pattern that will match such numbers properly. When working with such numbers, it is much easier if there is a delimiter such as space or comma.