Distance-Time data extraction

Hi,

I have got distance-time data, I wanted to know how to extract distance data at cut-off of </= 0.5 nm and the corresponding times? I have attached the text file to this question. I hope soemone will be able to direct me into the right direction.

Thank you in advance,

Akash

[Bob Thompson]

It is generally considered much simpler to load the entire file into matlab and then remove the excess data with logic indexing. It should look something like this.

data = dlmread('Minimumdistance.txt');
data = data(data(:,1)<=0.5,:);

[Akash Pandya]

Hi,

Your code worked for me. Say I wanted to apply the same threshold to multiple columns simultaneously, is this possible?

Akash

Answer 1

[Jake Santiago]

data = dlmread('Minimumdistance.txt');

data = data(data(:,1)<=0.5,:);

As Bob suggested, this would probably work for you.

Do elaborate your problem a little more if you still having trouble.

[Akash Pandya]

Hi,

So the above code worked. I have the various time points at which the distance is <= 0.5 nm. If I wanted to sum the time points how would I go about doing this?

And as I have 442 columns of distance data, how could I then apply the <=0.5 nm threshold to all the columns and get the corresponding time points?

Answer 2

[Dhanashree Mohite]

As per my understanding, as (distance<=0.5nm) and distance is 2nd column, so it should be:

data = dlmread('Minimumdistance.txt');
data = data(data(:,2)<=0.5,:);