Deleting line containing symbol.

Hi can You help me finish this command:

E(any(regexp(E, 'A|' , 'match' );,2),:) = [];

Deleting line in variable E(readed by textscan), containing A|.

Thank You.

Answer 1

[Azzi Abdelmalek]

 E={'| 00:00 | A| | A| A| A|'
   '| 00:15 | 1.21 | | 1.34 | 1.42 | 1.34 |'
   '| 00:30 | 1.42 | | 1.76 | 1.34 | 1.45 |'
   '| 00:45 | 1.23 | | 1.34 | 1.67 | 1.23 |'}
out=cellfun(@(x) strrep(x,'A|',''),E,'un',0)
out=cellfun(@(x) strrep(x,'|',''),out,'un',0)

[ZK]

Yest this is close, but not deleting whole line, but only A| from them.

[Azzi Abdelmalek]

Do you want to delete also | ?

[Azzi Abdelmalek]

E={'| 00:00 | A| | A| A| A|'
 '| 00:15 | 1.21 | | 1.34 | 1.42 | 1.34 |'
 '| 00:30 | 1.42 | | 1.76 | 1.34 | 1.45 |'
 '| 00:45 | 1.23 | | 1.34 | 1.67 | 1.23 |'}
out=cellfun(@(x) strrep(x,'A|',''),E,'un',0)
out=cellfun(@(x) strrep(x,'|',''),out,'un',0)

[ZK]

No I would like to delete whole line so the output should look like this:

E={'| 00:15 | 1.21 | | 1.34 | 1.42 | 1.34 |

| 00:30 | 1.42 | | 1.76 | 1.34 | 1.45 |

| 00:45 | 1.23 | | 1.34 | 1.67 | 1.23 |'}

[Azzi Abdelmalek]

Ok

E={'| 00:00 | A| | A| A| A|'
'| 00:15 | 1.21 | | 1.34 | 1.42 | 1.34 |'
'| 00:30 | 1.42 | | 1.76 | 1.34 | 1.45 |'
'| 00:45 | 1.23 | | 1.34 | 1.67 | 1.23 |'}
idx=find(cell2mat(cellfun(@(x) ~any(strfind(x,'A|')),E,'un',0)))
out=E(idx)

[ZK]

Working great. Thank You for Your time, and great answer of course.

Answer 2

[Azzi Abdelmalek]

E='assA|stA|'
idx=regexp(E,'A|')
E(idx+1)=[]

[ZK]

Thanks but this function should work in cells (as textscan is saving in cells).

[Azzi Abdelmalek]

E={'assA|stA|'}
E=E{1}
idx=regexp(E,'A|')
E(idx+1)=[]

Can you post a sample of your data?

[Azzi Abdelmalek]

%or

E={'assA|stA|';'azekaA|assaA|'}
for k=1:numel(E)
 a=E{k}
 idx=regexp(a,'A|')
 a(idx+1)=[]
 E{k}=a
end

[ZK]

Yes of course, sorry for that.

Example:

 E<1x1 cell>

 <4x1 cell>

| 00:00 | A| | A| A| A|

| 00:15 | 1.21 | | 1.34 | 1.42 | 1.34 |

| 00:30 | 1.42 | | 1.76 | 1.34 | 1.45 |

| 00:45 | 1.23 | | 1.34 | 1.67 | 1.23 |