MATLAB Answers


How to get Matlab read my char file in excel?

Asked by Matlaber on 10 Apr 2019
Latest activity Commented on by Jan
on 12 Apr 2019
Let say I have a csv file and have a list of char inside.
I want to read it as:
But not working.
>> x=dlmread('test10042019_char.csv',' ', 1,0);
Error using dlmread (line 143)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field
number 1) ==> ,\n
Thank you.


Sign in to comment.


1 Answer

Answer by Cris LaPierre on 10 Apr 2019
Edited by Cris LaPierre on 10 Apr 2019

dlmread shouldn't work. From the documentation: "(Not recommended) Read ASCII-delimited file of numeric data into matrix".
"M = dlmread(filename) reads an ASCII-delimited numeric data file into matrix M. The dlmread function detects the delimiter from the file and treats repeated white spaces as a single delimiter."
Your data is not numeric. It doesn't matter what options you add, it won't be able to reach text.
csvread has the same issue.
"M = csvread(filename) reads a comma-separated value (CSV) formatted file into array M. The file must contain only numeric values."
I would suggest using readtable
x = readtable('test10042019_char.csv')


It won't help you with cells and strings, but I suggest you take some time to go through MATLAB Onramp.
I know about the MATLAB Onramp before.
I just need some help in this.
on 12 Apr 2019
The message means, that you have created a function file called "filter.m", but this is a built-in function already. This can and will cause conflicts. Do not shadow built-in function by user-defined functions or variables.
You just need help in what? Strings, cell strings, char vectors and char matrices are explained exhaustively in the Getting Started chapters of the documentation and I assum in Matlab's OnRamp also. It would be rather inefficient, if I explain more, if there is a very good complete documentation already. Please learn the basics from there and ask a specific question on demand.

Sign in to comment.