creating numerical values from parts of a string read
2 次查看(过去 30 天)
显示 更早的评论
I have the following problem, I use the following to read in a string in a column in excel
[numerics,strings] = xlsread (filename,'spreadsheet name','Axx:Ayy')
filename is not in qoutes because it is read in from a user input using
filename = sprintf('filename',answer)
looking at the strings array I can see that the characters are read into the array
I need to extract part of the string and convert it into numerical values
the strings looks like 0(07/24/2014 10:39:10.21304) I need the last part of the string 10.21304
My approach was to first separate the string using command
strsplit(strings (2,1)) where strings (2,1)
is the location in the matrix of the strings; the error I can getting is that
First input must be a string.
So clearly I don't understand the issue - I tried the following
str1 = strings (2,1) and the output is '2 (07/24/2014 10:39:10.21304)'
Does the presence of the qoutation marks have anythings to do with the error ?
Any insight as to how to resolve the problem would be appreciated. I have google
several approaches and have not found anything that I can try. My first issue
resolving the error 'First input must be a string'
Regards, Philip
0 个评论
采纳的回答
Ben11
2014-8-6
If your strings are always of the same format, you can use regular expression to look for the colon followed by a number and followed by a dot, and then retrieve the numbers you want.
A = '0(07/24/2014 10:39:10.21304)'
ColonLocations = regexp(A,'\:\d*\.\d*','match')
which gives:
ColonLocations =
':10.21304'
Get rid of the colon:
ColonLocations{1}(1) = []
Convert to number:
ColonLocations = str2num(ColonLocations{1});
You can make this shorter by combining a few lines.
ColonLocations =
10.2130
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!