how to get string and numbers separately using csvread

Question

Elysi Cochin 2018-3-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/389453-how-to-get-string-and-numbers-separately-using-csvread

编辑： Jan 2018-3-20

How to get string and numbers separately from csv file using csvread. I have a csv file with "A-Z" numerical columns and 100 rows. Column "AA" is string

How to get the numerical and text field separately using csvread

M  = csvread(excelFileName, 1, 1, [1 1 100 26]);
Error using dlmread (line 143)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 27) ==>
Genuine,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...
Error in csvread (line 49)
    m=dlmread(filename, ',', r, c, rng);