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.
Nice! Sometimes it’s the simple things eh!
Neat!
I like it. I always had a looping script and using the value in a variable. It “fills” the next record, unless the value was already there, then it changes the variable used. But this does that with the Replace. Beauty!
I’m assuming this was just a quick Replace Field Contents from the menu. But it’s also worth noting that the Replace Field Contents script step can now be transactional, with the new Open/Revert/Commit Transaction script steps. That makes RFC less scary/problematic to use in scripts!
👏