Compare two strings present in excel?

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

Answer 1

[Raj]

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})