MATLAB: Reading a string with %

%readingreading strings

Hello,

I am trying to read in a list of strings from a .xls file, some of which contain a %. Since this is generally used to add comments to a block of code, the stings that contain %'s are being read into MATLAB as ''. Is there any way to read these strings into MATLAB so that they include the %? For example

'hello%mynameis'

, or should I just scrap them from my list?

Many Thanks, Charlie

Best Answer

Could you show the portion of code you're using to read your excel file?

The first output of xlsread is only the numeric content of the Excel file. However, you should be able to extract your string from the second or third output. That is, if all you're doing is:

data = xlsread('somefile.xlsx');

now do:

[data, text, raw] = xlsread('somefile.xlsx');

Related Solutions

MATLAB: How to read vector of strings into MATLAB

[numbers, strings, everything] = xlsread(filename);

MATLAB: 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

[~, ~, 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.

Best Answer

Related Solutions

MATLAB: How to read vector of strings into MATLAB

MATLAB: 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

Related Question