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.

Categories

Find more on Data Import and Export in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!