MATLAB: Way for matching letters and numbers in two files

characterscolumncommandfilesloopmatchnumbers

Hello,

I have a question about one code. I have two files. file1, has one column with numbers only. the second file (file2) has two column. in which the first column has numbers and the second columnn has letters/characters. I would like to add a new column in file1 which would have letters/characters, based on the file2 structure.

I send you some pics in order to see what I want to do.

file1

file2

final file

I attach the two files (final1.xlsx & file2.xlsx) and the final file (final_file.xlsx) I would like to create

could you help me please?

Best Answer

Not sure how file1 is involved. If you want to sort the cell array file2 based on the contents of column 1, use sortrows(ca, 1). If you need anymore help, attach the two files.

Related Solutions

MATLAB: How to load multiple .dat files into MATLAB

You can use the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F Use the second example. Then, inside the loop, read the data file with csvread(), readtable(), importdata(), or any of several other functions and append the data to your growing array. After the loop, create a filename and call xlswrite()

% Specify the folder where the files live.
myFolder = 'C:\Users\yourUserName\Documents\My Data'; % Wherever...
% Check to make sure that folder actually exists.  Warn user if it doesn't.
if ~isdir(myFolder)
  errorMessage = sprintf('Error: The following folder does not exist:\n%s', myFolder);
  uiwait(warndlg(errorMessage));
  return;
end
% Get a list of all files in the folder with the desired file name pattern.
filePattern = fullfile(myFolder, '*.dat'); % Change to whatever pattern you need.
theFiles = dir(filePattern);
for k = 1 : length(theFiles)
  baseFileName = theFiles(k).name;
  fullFileName = fullfile(myFolder, baseFileName);
  fprintf(1, 'Now reading %s\n', fullFileName);
  % Now do whatever you want with this file name,
  % such as reading it in, plotting it, using it, or whatever.
  dataArray = csvread(fullFileName); % Or whatever function you want.
  % Append data
  if k == 1
     allDataArray = dataArray;
  else
     allDataArray = [allDataArray; dataArray]; % Must have same number of columns
  end
end
xlswrite(outputFilename, allDataArray, 'All Data', 'A1');

MATLAB: Interleaving columns of two cell arrays

Here's a function I wrote for you. It contains a subfunction to create the interleaving index. Save this to interleaveCells.m and try calling it.

function c = interleaveCells(c1,c2)
% Make index for interleaving cells
ind = interleaveIndex(size(c1,2),size(c2,2));
% Combine cells
c = [c1, c2];
% Interleave cells
c = c(:,ind);
function ind = interleaveIndex(n1,n2)
ind = NaN(1, n1 + n2);
i = 1;
j = 1;
while i<=n1,
    ind(i+j-1) = i;
    i = i + 1;
    if j<=n2,
        ind(i+j-1) = n1 + j;
        j = j + 1;
    end
end
while j<=n2,
    ind(i+j-1) = n1 + j;
    j = j + 1;
end

Hope this helps.

Best Answer

Related Solutions

MATLAB: How to load multiple .dat files into MATLAB

MATLAB: Interleaving columns of two cell arrays

Related Question