Possible to loop through find and replace tool?

[dsucci]

Hi everyone,

Sorry if this is an easy fix i'm still getting my footing with learning designer, but i'm trying to match a list of countries to their respective continents. However the issue comes when there are multiple countries in 1 cell separated by | and have different continents, so when I use the find & replace it just goes after the first match and that's it, so i'm wondering if it's possible to loop it and match a continent to the various countries. Is this possible? Thanks again for any feedback it is greatly appreciated

[gabrielvilella · Accepted solution]

Hi @dsucci, see if this is what you are looking for. I noticed that some countries don't match, like you have United States in on table and US on another, you will need to correct this. Also, the only countries part of North America are Canada, United States and Mexico. There are a few there are from Central America, not North.

[dsucci]

That is perfect thank you! It seems so simple I think I was just severely overthinking it but it makes a lot of sense for how you did it thank you, and apologies for the messy data on the countries I quickly put it together for this and didn't double check it.

[gabrielvilella]

No problem @dsucci! Happy to help :)