Info
This question is closed. Reopen it to edit or answer.
importing a column of data from a text file
    4 views (last 30 days)
  
       Show older comments
    
i need to import a particular column of data from a text file. the columns are differentiated by the size of the numbers. For example :
20 30000
21 40000
24 50000
how can i do so?
0 Comments
Answers (2)
  Azzi Abdelmalek
      
      
 on 29 May 2013
        
      Edited: Azzi Abdelmalek
      
      
 on 29 May 2013
  
      Import the data using
data=dlmread('yourfilename.txt')
Then choose the column you want
data(:,2)
% You can get the sizes of numbers in each column
numbers=arrayfun(@(x) numel(num2str(x)),data(1,:))
3 Comments
  Azzi Abdelmalek
      
      
 on 29 May 2013
				
      Edited: Azzi Abdelmalek
      
      
 on 29 May 2013
  
			data=dlmread('yourfilename.txt')
numbers=arrayfun(@(x) numel(num2str(x)),data(1,:))
[idx,idx]=max(numbers)
result=data(:,idx)
  Azzi Abdelmalek
      
      
 on 29 May 2013
				or simply
data=dlmread('yourfilename.txt')
[idx,idx]=max(data(1,:))
result=data(:,idx)
  Andrei Bobrov
      
      
 on 29 May 2013
        
      Edited: Andrei Bobrov
      
      
 on 29 May 2013
  
      d = dlmread('yourtxtfile.txt');
[k,k] = max(log10(d(1,:)));
out = d(:,k);
or
[k,k] = max(log10(d(:)));
out = d(:,ceil(k/size(d,1)))
0 Comments
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

