Importing data from xls file 1

[rm2]

Hello

I am indexing information from a xls file, most of it by columns. How can I place conditions to the importing data?
i.e. Indexing data from Col1 that is greater than 0
Col 1
3
4
5
0
9

variablex= data ,1) IF >0 ?????????????

thanks for your help

 

[custodes]

This is how I would do it.

%this returns the indeces of all nonzero elements of A to elements of X.

X=find(A)

%this makes a new matrix (column vector) that is as long as X but with the elements in A, which have indeces given by the elements of X

B(1:size(X))=A(X)

%Just make a function that imports the variable, runs it through this program, and then spits it into the workspace or a .mat file or whatever.

Custodes

 

[rm2]

thanks

 

[SomptingGuy]

A simpler method using "logical indexing" is this:

A=A(A~=0);

No need to use find().

- Steve