clear;clc;
load D;
for i=1:167
for j=1:3
n=3*(i-1)+j;
if ~isempty(findstr(D{n,1},'2')) || ~isempty(findstr(D{n,1},'3'))
if j==1
E{i,1}=[D{n,1},D{n+1,1},D{n+2,1}];
elseif j==3
E{i,1}=[D{n,1}(1:6),D{n-2,1},' ',D{n-1,1},' ',D{n,1}(7:end)];
end
end
end
end
RES2={};
%队号
for i=1:length(E)
RES2{i,1}=E{i,1}(1:6);
E{i,1}(1:6)=[];
end
%奖项
for i=1:19
RES2{i,6}=E{i,1}(end-18:end);
E{i,1}(end-18:end)=[];
end%M
for i=20:75
RES2{i,6}=E{i,1}(end-17:end);
E{i,1}(end-17:end)=[];
end%H
for i=76:167
RES2{i,6}=E{i,1}(end-22:end);
E{i,1}(end-22:end)=[];
end%S
%选题
for i=1:length(E)
RES2{i,5}=E{i,1}(end-1:end);
E{i,1}(end-1:end)=[];
end
%国别
for i=1:length(E)
Q=findstr(E{i,1},'China');
M=findstr(E{i,1},'USA');
N=findstr(E{i,1},'Hong Kong SAR');
if ~isempty(Q)
RES2{i,4}=E{i,1}(Q(end)+6:end);
E{i,1}(Q(end)+6:end)=[];
RES2{i,3}=E{i,1}(Q(end):Q(end)+5);
E{i,1}(Q(end):Q(end)+5)=[];
elseif ~isempty(M)
RES2{i,4}=E{i,1}(M(end)+4:end);
E{i,1}(M(end)+4:end)=[];
RES2{i,3}=E{i,1}(M(end):M(end)+3);
E{i,1}(M(end):M(end)+3)=[];
elseif ~isempty(N)
RES2{i,4}=E{i,1}(N(end)+14:end);
E{i,1}(N(end)+14:end)=[];
RES2{i,3}=E{i,1}(N(end):N(end)+13);
E{i,1}(N(end):N(end)+13)=[];
end
end
for i=1:length(E)
RES2{i,2}=E{i,1};
end