How to get Matlab read my char file in excel?

5 views (last 30 days)
Matlaber on 10 Apr 2019
Commented: 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.

Answers (1)

Cris LaPierre
Cris LaPierre on 10 Apr 2019
Edited: 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')
Jan 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.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!