Kirix Strata Blog

Archive for the ‘replace values’ Category

Updating and Replacing Values in Cells

Friday, July 18th, 2008

Strata Tips and TricksWe had a really good question come up in our forums regarding Strata’s ability to replace values within cells.

Bottom line, if you have a value in one field and want to auto-replace it with a different value, you can easily do this using the Update Records tool (Data > Update Records…).  In a nutshell, it works like this:

  1. Choose the field you want to update.
  2. Choose the new value you want to update with.
  3. Create the logic to let Strata know when to update a cell and when not to update a cell.

Both #2 and #3 enable you to get pretty complex, since you can use formulas in both of these areas.  The “update with” (#2) area can be particularly tricky, since it gives you the ability to transform values on the fly.

However, it had been a while since I’d personally gone through the various options one can use to replace records, but as I did, I quickly realized our documentation wasn’t comprehensive enough.

So, I added the “replace” rules to the post here.

Hope this helps.  Now, if I only could figure out a way to replace Friday with Saturday… :)  Hope everyone has a good weekend!

P.S.  Got a question about Strata that you’ve been curious about?  Please post a note on the support forums and we’ll be happy to help!