Read csv file and remove some strings

2 views (last 30 days)
I have a csv file which has values like the following:
0.0,-3.3,,
0.0,-4.9,,
0.1,-5.1,,
0.1,-5.8,,
When I use the csvread command then the two commas are mixing up my matrix and instead of having a matrix 4 by 2 I get a matrix 4 by 4 because in each line the commas are replaced by zeros. So instead of getting a matrix
0.0 -3.3
0.0 -4.9
etc...
I get a matrix
0.0 -3.3 0 0
0.0 -4.9 0 0
How can I remove the two commas?

Answers (1)

Thomas
Thomas on 19 Apr 2013
Thats easy - don't. Just truncate the matrix:
A = A(:,1:2)
e.g. extract all rows and columns 1-2.

Community Treasure Hunt

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

Start Hunting!