Find addresses from one file in another file then save into a third file
1 次查看(过去 30 天)
显示 更早的评论
I'm trying to make a code that takes in a file of addresses (fileA), searches for that address in another file (fileB), then saves that line of data into another file (outputFile).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1562354/image.png)
It runs fine but there's no data in the outputFile. I think the problem I'm running into is the data within the tables. I've tried a few different file formats (.csv, .xls, etc.) and sometimes the addresses show up as NAN and sometimes they show up with too many quotes around them (like this: ""address""). Is there a better way I can be formatting these? Any tips on the code? Thanks!
2 个评论
采纳的回答
Sulaymon Eshkabilov
2023-12-6
(1) That would be helpful to see your sample data file.
(2) You can also try contains() fcn as well, e.g.:
Match_Row = contains(TableB.Address, currentAddress, IgnoreCase=true);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!