How to delete values when value is 3&4 then 7&8 then 11&12....

I have attached a mat file below.

1 repeates like 162 times

2 repeates like 172 times

I want to

keep 1 & 2

remove 3&4

keep 5&6

remove 7&8

keep 9&10

remove 11&12

so on.......

Answer 1

[Temu Gautama]

Hi,

Something like

A(rem(A+1,4)>1)

hth,

Temu

[CalebJones]

works thank you

[CalebJones]

Hey @Temu Gautama

The following part works perfectly

tmp.eventid(rem(tmp.eventid+1,4)>1));

However when I'm doing the following it doesn't seem to work. What I mean is from all results it now removing rows with eventid 1,2 keep...3,4 remove....5,6 keep....7,8 remove so on....

tmp = allresults;
tmp = tmp(find(tmp.eventid(rem(tmp.eventid+1,4)>1)),1:4);

[CalebJones]

tmp = allresults;
tmp = tmp(find(rem(tmp.eventid+1,4)>1),1:4);

Fixed it.

Answer 2

[KSSV]

If you have an array A...To remove a specific element use:

A(A==val) = [] ;

[CalebJones]

Val has to be manually entered right, I want to code it such with some sort of logic.

[KSSV]

val can be 3, 4, 7, 8 etc,.