Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
This one took me quite a while! And it would have been so simple to take the easy path...
Thanks for the challenge!
my easy solution
So this was an easy one Huh?
Well not for me, I first tried the Macro way but gave up, it was still to advanced for me.
Since I have literally spent weeks (well on and off), I could see where @JoeM want us to go, so thanks for pushing us to learn a new tool.
I do not think it is too much a spoiler to write Dynamic Replace, since it at least to me, was a bit tricky to learn.
The built in help wasn't much help to me, but luckily we do have the Tool Mastery | Dynamic Replace.
After reading that (several times. before I finally understood this tool) I was able to provide the solution.
And I must admit, that the Dynamic Replace is a nifty tool, and especially for this task, so once again - thanks again to
@JoeM for pushing me in that direction.
As I have stated, after I had read the Tool Mastery | Dynamic Replace a couple of times, I began to get an conceptual understanding on how this tool works, and here is my short interpretation
The tool takes three parameters
The first is the field name that you would like to replace
The second is the boolean expression that you wish to check for.
And the third is the value that in case the boolean expression is valid is substituted with
Now the "tricky" part is how to write that boolean expression, and it took me a couple of attempts to get it working, so do not despair
Try and try again - I did, and did learn something new on the way.
Until next time
/Thomas