This afternoon I pulled this data into FileMaker from a spreadsheet, and needed to “fill down” the region names in f2.
Of course I could have filled the region down in Excel prior to importing, but here I was already in FM. At first I was going to use a looping script, but then it occurred to me that it would be nice if Replace could do the trick.
I was curious whether this Replace logic would work…
Yep, works just fine.
[Update 13 July 2026 – see also More Fun With Replace.]