How to compare these two strings?

5 次查看（过去 30 天）
Manny
Manny 2024-2-18
评论： Manny 2024-2-19
Hi everyone
I am trying to compare two strings but I am getting an error. I am new to Matlab so most likley I made a rookie error. Is someone able to help me?
I have an array of symbols and an array of data. The symbol list is called UnderlyingSymbols and data array is called CIV. I need to filter CIV based on a symbol because I am going to be using this as part of a for loop. For each symbol in UnderlyingSymbols, find the corresponding records in CIV. Both CIV and UnderlyingSymbols has a field called Symbol. I am not sure how to fix the error I am getting. How do I fix it?
Code:
% LOAD TABLES FROM SQL SERVER
CIV = sqlread(ConnectionString,'CompositeImpliedVolatility');
% CREATE ARRAY OF SYMBOLS
UnderlyingSymbols = unique(CIV(:,1));
FilteredCIV = CIV(CIV.SYMBOL == UnderlyingSymbols(1,1),:);
Error:
Error using ==
This operation is not defined between 'table' and 'cell'. The input that is not a table or timetable must
be a numeric or logical array.
Error in ForecastModel (line 51)
FilteredCIV = CIV(CIV.SYMBOL == UnderlyingSymbols(1,1),:);
Output from UnderlyingSymbols:
SYMBOL
_______
{'SPX'}
Output from CIV:
SYMBOL TRADE_DATE
_______ ___________
{'SPX'} 03-Jun-2014
{'SPX'} 11-Jun-2014
Thank you
  2 个评论
Sulaymon Eshkabilov
Sulaymon Eshkabilov 2024-2-18
Pl, share ConnectionString data. So community people can simulate your exercise.
Image Analyst
Image Analyst 2024-2-18
Can you attach CIV in a .mat file so we can try the rest of your code, that is ONLY if the code by @VBBV (below) didn't work?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

VBBV
VBBV 2024-2-18
编辑：VBBV 2024-2-18
try using strcmp function
FilteredCIV = CIV(strcmp(CIV.SYMBOL,UnderlyingSymbols.SYMBOL(1)),:); % try using strcmp
  3 个评论
显示 1更早的评论
VBBV
VBBV 2024-2-18
If there is a field in UnderlyingSymbols then acceess the field content using its name
Manny
Manny 2024-2-19
thank you so much. the strcmp works!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by