text to column conversion
4 views (last 30 days)
Show older comments
Rashmil Dahanayake
on 2 Jun 2014
Commented: Roger Wohlwend
on 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 Comments
Accepted Answer
Roger Wohlwend
on 2 Jun 2014
n = length(tags);
tags_new = cell(n,2);
for k = 1 : n
tags_new(k,:) = strsplit(tags{k},' ');
end
2 Comments
Roger Wohlwend
on 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
More Answers (0)
See Also
Categories
Find more on Data Import and Export in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!