text to column conversion
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Rashmil Dahanayake
am 2 Jun. 2014
Kommentiert: Roger Wohlwend
am 3 Jun. 2014
Hi, I have a cell array and I'm seeking to separate two words and save them in 2 columns.
say the original cell array is tags and the modified array should look as follow
tags={'C=10.0mF L=1.0mH', 'C=10.0mF L=10.0mH' ,'C=50.0mF L=6.0mH'}
% I would like to have a script to bulil tags_new in the following format
tags_new={'C=10.0mF' 'L=1.0mH' ; 'C=10.0mF' 'L=10.0mH' ;'C=50.0mF' 'L=6.0mH'}
The idea is to detect the space delimiter before "L=" and move it to a different column.
This is achievable excel using "text to columns function"
0 Kommentare
Akzeptierte Antwort
Roger Wohlwend
am 2 Jun. 2014
n = length(tags);
tags_new = cell(n,2);
for k = 1 : n
tags_new(k,:) = strsplit(tags{k},' ');
end
2 Kommentare
Roger Wohlwend
am 3 Jun. 2014
n = length(tags);
tags_new = cell(n,2);
for k = 1 : n
z = find(tags{k} == ' ');
tags_new{k,1} = tags{k}(1:z-1);
tags_new{k,2} = tags{k}(z+1:end);
end
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import and Export finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!