text to column conversion
    8 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 Characters and Strings 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!
