Challenge #119: Inspire Weekly Challenge

[adampowers]

I agree, I believe the expected response is incorrect.  No spaces between letters and it provides "/" rather than ".-.-.-" for the period.

[NicoleJohnson]

Quick comment to give @ credit to two of the “Team Awesome” Weekly Challenge members who are now new members of the Alteryx Community... welcome, @smclerran & @Bradg!! It was so great having you two on our team, and I’m looking forward to seeing the cool things you continue to discover while exploring this incredible Community resource! See you at the next Inspire!!

Cheers, NJ

[patrick_digan]

As I looked through other answers and talked to @DultonM about something unrelated to this challenge, I realized that I completely over complicated my solution in my rush to get it done.

Spoiler

I use the Find Replace tool all the time, but I'm usually just using it to append data. I completely didn't realize that you could replace multiple items when using it for replacing. That little fun fact makes my solution much simpler:

[JoeM]

@DataRangler, sorry for the delayed response. We are all flying home from our conference today. Good catch - I mistakenly uploaded the wrong file in the heat of our live session. It's been updated to have the latest version. 

[SeanAdams]

:-) nice way to spend the time in the airport, waiting for the outbound flight.

Super over-complicated compared to some of the solutions posted above

Spoiler

Did this in the 3 phases posted in the problem.     After looking at the other solutions I could have done this MUCH easier by using the power of the replace tool; and the ability for Text to Columns to ignore blank results.

Phase 1:


Phase 2:


Phase 3:

[trodriguez91]

This was kind of cool to take a reference from the web and then utilize it when decoding data.

Spoiler

[trodriguez91]

Spoiler

[estherb47]

Not entirely sure if posting here is kosher, having had a big hand in designing this, but here's my solution :)

[TylerNa]

Summited!