Find addresses from one file in another file then save into a third file

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!

[Stephen23]

"Any tips on the code?"

Replace the FOR-loop with ISMEMBER. Read its documentation carefully: ISMEMBER has multiple outputs.

Pay attention to the orange underlining: expanding arrays inside loops is inefficient.

[BianH]

The addresses tabulated, thank you for the advice!

Answer 1

[Sulaymon Eshkabilov]

(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);

[BianH]

I messed around with it a bit more and I think the "contains" function is what did it. The addresses are tabulating now.

Thank you so much!

[Sulaymon Eshkabilov]

Most welcome!