Compare two strings present in excel?

1 次查看(过去 30 天)
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

采纳的回答

Raj
Raj 2019-7-15
编辑:Raj 2019-7-15
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 个)

类别

Help CenterFile Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by