Challenge #483: Spy Craft

[ahsanaali]

Spoiler

 

Magical! understanding the question was 95% of the challenge :)

[Carolyn]

Solved! I originally built this calling the fields "Original" and "Replacement" and then ended up hopelessly confused. I rebuilt it with "Encoded" and "Decoded" which was a lot easier to keep track of :)

Spoiler

[TH]

This one was OK. I think that I learned/accomplished a few things here.

0. Sometimes the problem is poorly worded, imprecise, or can be interpreted multiple different ways. There is no shame in asking for or searching out clarification and explanation.

1. I got to practice a different way to do an iterative macro than you usually get in the demonstrations (where they rely on iteration number for stopping).

2. I learned that using the Find/Replace tool can cut down on the number of other tools I need to use.

3. The "Join" tool, like the "Unique" tool, does some sorting behind the scenes, so it is not the best tool for cases where the order of things is important.

4 The "Find/Replace" tool requires strings for finding and replacing. You cannot use numbers.

5. By going to "Options->Export Workflow" you can save your main workflow along with any necessary sub macros. This creates a .yxzp file (instead of yxmd or yxmc) that includes your main workflow and all the included macros and will work when someone else downloads it or opens it on their computer.

Spoiler

[Erin]

Honestly, the hint was lost on me. The whole thing was lost on me really. Thank you so much @alineruizcampos because I leaned heavily on your posted solution! I did change it up just slightly.

Spoiler

workflowiterative macro

[AkimasaKajitani]

My solution.

Spoiler

[dougperez]

I had a hard time understanding this challenge.

Spoiler

Workflow:

Macro:

[ANNE_LEROY]

I suffered ! 😥

[tammybrown_tds]

Macros are my achilles heel.  I needed to look to others' solutions for support.

[alacoume]

Very interesting!

Spoiler

[stataltgee]

this was quite a challenge  🤕