MATLAB Answers

Compare two strings present in excel?

3 views (last 30 days)
Harsha Nimje
Harsha Nimje on 15 Jul 2019
Edited: Raj on 15 Jul 2019
I have two strings in excel
  1. BatOverUFlt
  2. Rd_FltMon_BatOverUFlt_write
I need to compare these strings and bring the answer as 1 and then connect those signals
kindly help

  0 Comments

Sign in to comment.

Accepted Answer

Raj
Raj on 15 Jul 2019
Edited: Raj on 15 Jul 2019
Is this what you are looking for?
%% Import the data
[~, ~, raw] = xlsread('C:\Users\User\Documents\MATLAB\TEST.xls','Sheet1');% Asuming you have the 2 strings in 2 columns of sheet 1 of excel named TEST. Update as per your file accordingly.
raw(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),raw)) = {''};
cellVectors = raw(:,[1,2]);
%% Allocate imported array to column variable names
A = cellVectors(:,1);
B = cellVectors(:,2);
%% Clear temporary variables
clearvars data raw cellVectors;
C = strsplit(B{1},'_');
Required_Answer=isequal(A{1},C{3})

  0 Comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Tags