search for a string in other file and return new files based on multiple condiion

2 次查看（过去 30 天）
sensation
sensation 2017-10-19
评论： sensation 2017-10-20
Hi and I hope you can give me some advice or suggestion,
I have bunch of files and what I would like is to create new files based on a condition. For example my input files are curva_pbc_uof_20150103.txt and curva_pbc_uof_20150104.txt and condition is in cond.txt file.
I would like to create new files where fourth column of my files matches conditions, so if I have ABO1 in curva_pbc_uof_20150103.txt and ABO1 in cond.txt, I should keep those rows, and in addition only those rows where the last column is equal to C. All other rows should be neglected.
Thanks a lot!

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-10-19
编辑：Andrei Bobrov 2017-10-19
n = dir('curva_pbc_uof_*.txt');
nn = {n.name}';
k = numel(nn);
c = readtable('cond.txt','ReadVariableNames',false);
c = regexp(c.Var1,'\w*','match','once');
T_out = cell(k,1);
for ii = 1:k
T = readtable(nn{ii},'delimiter',';','DatetimeType','text','ReadVariableNames',true);
if ii == 1
a0 = T.Properties.VariableNames;%if ii = 1
a1 = a0(6:7);
end
T = T(:,~strncmp(a0,'Var',3));
T.Fecha = datetime(T.Fecha,'F','dd/MM/uuuu');
T{:,a1} = regexprep(T{:,a1},{'\.',','},{'','\.'});
b = array2table(str2double(T{:,a1}),'v',a1);
T(:,a1) = [];
T(:,a1) = b;
T_out{ii} = T(ismember(T.Unidad,c) & strcmp(T.Ofertada_O__Casada_C_,'C'),:);
end
  9 个评论
显示 7更早的评论
Andrei Bobrov
Andrei Bobrov 2017-10-20
编辑：Andrei Bobrov 2017-10-20
c = unique(c);
[lo,ii] = ismember(T_last{:,2},c);
[g1,dat] = findgroups(T_last(:,1));
n = strcat('v_',c(:)');
sum1 = [dat,array2table(accumarray([g1,ii],T_last.sum,[],[],nan),'v',n)];
max1 = [dat,array2table(accumarray([g1,ii],T_last.max,[],[],nan),'v',n)];

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by