Azzera filtri
Azzera filtri

text to column conversion

2 visualizzazioni (ultimi 30 giorni)
Rashmil Dahanayake
Rashmil Dahanayake il 2 Giu 2014
Commentato: Roger Wohlwend il 3 Giu 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"

Risposta accettata

Roger Wohlwend
Roger Wohlwend il 2 Giu 2014
n = length(tags);
tags_new = cell(n,2);
for k = 1 : n
tags_new(k,:) = strsplit(tags{k},' ');
end
  2 Commenti
Rashmil Dahanayake
Rashmil Dahanayake il 2 Giu 2014
thanks, but Matlab 2012a doesn't have the strsplit().
Roger Wohlwend
Roger Wohlwend il 3 Giu 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

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Data Import and Export in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by