Updating and Replacing Values in Cells
Friday, July 18th, 2008
We 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:
- Choose the field you want to update.
- Choose the new value you want to update with.
- 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!
