MATLAB: Math operations with Imported Data from Text

data import

I have imported a text file. When I multiply the cells such as, filename(4,7)*filename(6,5); I get an error. I extracted data as cells since it includes both strings and the numbers. How can I handle this problem?

Best Answer

filename{4,7}*filename{6,5}

Related Solutions

MATLAB: Problem with matrix composed of numbers and strings

Matrices cannot be composed of a combination of character and numeric information. They must be character, or they must be numeric. When you used vertcat here, MATLAB converted the numeric array into its ascii equivalent, using the ascii tables.

c = [a;b]
c =
hello
whos c
  Name      Size            Bytes  Class    Attributes
  c         2x5                20  char

So what happened? c is a character array, of size 2x5. But that second row of characters were unprintable. So you just see white space when you display the matrix c.

But the position of the character 1 in the ascii table is 49. So when MATLAB tries to convert 1 using the ascii tables, it converts to an unprintable character, NOT the character '1'.

+'1'
ans =
    49

If you REALLY wanted to combine the two, into a readable array, then try this:

c = [a;b+48]
c =
hello
12345

Alternatively, you can use a cell array, but it won't be terribly readable as a composite array as I think you want to see.

MATLAB: How to replace strings in a cell array

>> C = {'A', 'B', 'C', 'D', 'QQQQ_01', 'E', 'QQQQ_02'}
>> X = find(strncmp(C,'QQQQ',4));
>> C(X) = strcat('Q_',C(X-1))
C = 
    'A'    'B'    'C'    'D'    'Q_D'    'E'    'Q_E'

You will have to decide how to handle if the first cell contains 'QQQQ'.

Best Answer

Related Solutions

MATLAB: Problem with matrix composed of numbers and strings

MATLAB: How to replace strings in a cell array

Related Question