Compare two strings present in excel?
2 ビュー (過去 30 日間)
古いコメントを表示
I have two strings in excel
- BatOverUFlt
- Rd_FltMon_BatOverUFlt_write
I need to compare these strings and bring the answer as 1 and then connect those signals
kindly help
0 件のコメント
採用された回答
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 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!