How to get Matlab read my char file in excel?

4 views (last 30 days)
Matlaber
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.
Capture1.PNG
I want to read it as:
Capture2.PNG
x=dlmread('test10042019_char.csv');
y=csvread('test10042019_char.csv');
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')
  8 Comments
Matlaber
Matlaber on 11 Apr 2019
I know about the MATLAB Onramp before.
I just need some help in this.
Jan
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.

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!