How to compare these two strings?
显示 更早的评论
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
2024-2-18
Pl, share ConnectionString data. So community people can simulate your exercise.
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?
采纳的回答
try using strcmp function
FilteredCIV = CIV(strcmp(CIV.SYMBOL,UnderlyingSymbols.SYMBOL(1)),:); % try using strcmp
3 个评论
SYMBOL = {'SPX','SPX','SPY'}.';
TRADE_DATE = {' 03-Jun-2014','11-Jun-2014','14-Jun-2014'}.'
CIV = table(SYMBOL,TRADE_DATE)
UnderlyingSymbols = table(SYMBOL)
FilteredCIV = CIV(strcmp(CIV.SYMBOL,UnderlyingSymbols.SYMBOL(1)),:) % try using strcmp
VBBV
2024-2-18
If there is a field in UnderlyingSymbols then acceess the field content using its name
Manny
2024-2-19
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Types 的更多信息
Translated by 
