How can i get the numbers from an Excel document? like if we have L/22, and we want to get the number 22 out?

Question

Matias Holm Andersen on 8 Jun 2015

0
Link

Direct link to this question

https://www.mathworks.com/matlabcentral/answers/222950-how-can-i-get-the-numbers-from-an-excel-document-like-if-we-have-l-22-and-we-want-to-get-the-numbe

Commented: Rena Berman on 24 Jan 2017

Accepted Answer: Guillaume

2 Comments
Show NoneHide None

Guillaume on 9 Jun 2015

Do not edit away your question. It's really unfair to the people who spend time answering your question.

The original question was about reading the numbers in an excel spreadsheet, where some of them are preceded by letters.

Rena Berman on 24 Jan 2017

(Answers dev) Restored question.

Sign in to comment.

Sign in to answer this question.

Answer 1

Guillaume on 8 Jun 2015

0
Link

Direct link to this answer

https://www.mathworks.com/matlabcentral/answers/222950-how-can-i-get-the-numbers-from-an-excel-document-like-if-we-have-l-22-and-we-want-to-get-the-numbe#answer_181955

[~, ~, raw] = xlsread('somefile.xlsx'); %read raw content of excel file
numtext = regexp(raw, '\d+', 'match', 'once'); %extract 1st sequence of digits of each cell
numbers = cellfun(@str2double, numtext) %convert strings to numbers.

will do it, assuming that the numbers are all integers (otherwise the regular expression has to be more complex).

Alternatively, create a new table in excel with a formula that creates a copy of the data while stripping the non-numeric characters and import that table in matlab.