Find addresses from one file in another file then save into a third file
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
BianH
il 6 Dic 2023
Commentato: Sulaymon Eshkabilov
il 8 Dic 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).
![](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 Commenti
Risposta accettata
Sulaymon Eshkabilov
il 6 Dic 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);
2 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!