MATLAB: Counting occurrence of matched strings in multiple columns

matched stringsoccurrence

Hi:

Give that: TN = {Hex1}, DS= {Hex15, Hex16… Hex20}, Names= { Hi, Hello}. I want to count the occurrence of the matched strings from column A,B, and E of the string Hi with any of the elements in DS with the element in TN. I should have 2 occurrences as shown in the attached file (highlighted in Blue). Thanks!

Best Answer

One possible solution would be like this.

TN = {'Hex1'};
DS = {'Hex15','Hex16','Hex17','Hex18','Hex19','Hex20'};
[~,txt] = xlsread('Myfile.xls');
idx =...
  ismember(txt(:,1),TN) &...
  ismember(txt(:,2),DS) &...
  strcmp(txt(:,5),'Hi');

The result is:

>> txt(idx,:)
ans =
2×5 cell array
  {'Hex1'}    {'Hex15'}    {0×0 char}    {0×0 char}    {'Hi'}
  {'Hex1'}    {'Hex20'}    {0×0 char}    {0×0 char}    {'Hi'}

Related Solutions

MATLAB: Selecting part of a string

surely not the best way to do it but here is my way

v=['a.txt' 'b.txt' 'c.txt' 'd.txt']
cell2mat(arrayfun(@(x)strtok(x,'.txt'),v,'uni',false))

v=['a.txt' 'b.txt' 'c.txt' 'd.txt']'
cell2mat(arrayfun(@(x)strtok(x,'.txt'),v,'uni',false))

MATLAB: Parsing a Large Text File into Sections

Hi Amanda,

This should work for you. It just reads the input file one line at a time and prints that line to an output file. If it hits a new "section", it makes a new output file named by that section.

fidIn = fopen('inputFile.txt','r');
oldFirstChars = 'somethingtostart';
fidOut = [];
while 1
    tline = fgetl(fidIn);
    if ~ischar(tline), break, end % Handle the end of the input file
        % Get the string up to the first space
        newFirstChars = regexp(tline, '\d+','match','once');
        % If it's a new "section", make a new file
        if ~strcmp(oldFirstChars, newFirstChars)
            if ~isempty(fidOut)
                % Close the old file first
                fclose(fidOut);                      
            end 
            fidOut = fopen(['outputFile' newFirstChars '.txt'],'w');
            oldFirstChars = newFirstChars;
        end
        % Just print out the line that we just read to the output file
        fprintf(fidOut, '%s\r\n',tline);
    end
  % Clean up any open files
  fclose(fidIn);
  fclose(fidOut);

Best Answer

Related Solutions

MATLAB: Selecting part of a string

MATLAB: Parsing a Large Text File into Sections

Related Question