Mismatch between file and format string.

8 views (last 30 days)
reza
reza on 21 Jan 2019
Commented: reza on 21 Jan 2019
Hi there,
I am trying to read the fifth column of attached .CSV file(from row 1377 to 1192) with this simple code:
data = csvread('semga.csv');
CLOSE = data(1377:1192,5);
But I get this error:
Error using dlmread (line 147)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==>
DATE,OPEN,HIGH,LOW,CLOSE,PRICE,YCLOSE,VOL,TICKS\n
Error in csvread (line 48)
m=dlmread(filename, ',', r, c);
Error in sorting (line 8)
data = csvread('semga.csv');
What is the problem and how can I fix it?

Sign in to answer this question.

Accepted Answer

Stephan
Stephan on 21 Jan 2019
Edited: Stephan on 21 Jan 2019
Hi,
use readtable, then extract the data from the variable CLOSE (=column named CLOSE) in ascending order:
data = readtable('semga.csv');
CLOSE = data.CLOSE(1191:1376);
Note that your table has only 1376 entries, since the first row are variable names. So i changed
(1192:1377)
to
(1191:1376)
If needed use flip function, to get the order you want:
CLOSE = flip(CLOSE)
Best regards
Stephan
  3 Comments
Show 1 older comment
Stephan
Stephan on 21 Jan 2019
Edited: Stephan on 21 Jan 2019
you could use the round function:
CLOSE = round(CLOSE)

Sign in to comment.

More Answers (0)

Categories

Find more on Text Files 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!