split a row into 2 rows
显示 更早的评论
cg00008493 0.987979722052904 "COX8C;KIAA1409" 14 93813777 0.986128428295584 "COX8C;KIAA1409" 14 93813777
cg00031162 0.378288688845672 "TNFSF12;TNFSF12-TNFSF13" 17 7453377 0.362510745266914 "TNFSF12;TNFSF12-TNFSF13" 17 7453377
here are 2 lines and each line have 8 columns, i want to split each line have 2 sets like "COX8C;KIAA1409" into 2 rows and delete the duplicated columns output should be like this:
cg00008493 0.987979722052904 COX8C 0.986128428295584
cg00008493 0.987979722052904 KIAA1409 0.986128428295584
cg00031162 0.378288688845672 "TNFSF12 0.362510745266914
cg00031162 0.378288688845672 TNFSF12-TNFSF13 0.362510745266914
fid = fopen('COADREAD_methylation.txt','r');
data={};
while ~feof(fid)
l=fgetl(fid);
if isempty(strfind(l,'NA')), data=[data;{l}]; end
a = reshape(l, ',','""', [])';
end
fid=fclose(fid);
Note: I used NA to remove the lines which have NA
采纳的回答
opt = {'CollectOutput',true};
inp = '%s%s%q%*d%*d%s%*q%*d%*d';
out = '%s\t%s\t%s\t%s\n';
f1d = fopen('temp1.txt','rt'); % the original file
f2d = fopen('temp2.txt','wt'); % the new file
while ~feof(f1d)
C = textscan(f1d,inp,1,opt{:});
C = [C{:}];
D = regexp(C{3},';','split');
for k = 1:numel(D)
fprintf(f2d,out,C{1:2},D{k},C{4});
end
end
fclose(f1d);
fclose(f2d);
Produces this output file:
cg00008493 0.987979722052904 COX8C 0.986128428295584
cg00008493 0.987979722052904 KIAA1409 0.986128428295584
cg00031162 0.378288688845672 TNFSF12 0.362510745266914
cg00031162 0.378288688845672 TNFSF12-TNFSF13 0.362510745266914
Tested on this input file:
18 个评论
chocho
2017-2-16
chocho
2017-2-17
chocho
2017-2-17
Stephen23
2017-2-17
@chocho phD: you need to provide the correct filepath to fopen.
chocho
2017-2-17
chocho
2017-2-18
Image Analyst
2017-2-18
He used f1d (eff one dee) and f2d (eff two dee), not fid2 (eff eye dee two).
chocho
2017-2-18
@chocho phD: do not work in that directory.
That is the installation directory of MATLAB. It is not intended for your to use any installation directory for working in. NEVER use any of the Program Files folders for your MATLAB current directory.
You should be using a subdirectory of your user directory, e.g.:
C:\Users\<your user name>\Documents\MATLAB\Working
Walter Roberson
2017-2-18
"C:\Program Files (x86)\MATLAB\R2012a this is the file path in which i'm working on"
You cannot write to any directory under "C:\Program Files (x86)" because MS Windows will not allow that. You need to cd to a different directory and work there.
chocho
2017-2-18
chocho
2017-2-22
chocho
2017-2-22
Stephen23
2017-2-22
If textscan has an empty output then you probably need to check the format string.
chocho
2017-2-22
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 File Operations 的更多信息
Translated by 
