Find addresses from one file in another file then save into a third file
1 view (last 30 days)
Show older comments
BianH
on 6 Dec 2023
Commented: Sulaymon Eshkabilov
on 8 Dec 2023
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).
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 Comments
Accepted Answer
Sulaymon Eshkabilov
on 6 Dec 2023
(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);
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!