Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

It's more fun to do it in a dynamic way.

Quite late to the party ! Here is my solution

Fun and made me think!

Key is to convert to string then pad with zeros then parse and convert back to byte.

And now we wait for Part 2 ...

Solution attached

this was fun. Looking forward to part II

Nice Solution! I tried to do the same dynamic append method but hard coded the Regex Token to 12 columns. I didn't think about splitting to rows and then using cross tab - good idea!

Nice Solution! I tried to do the same dynamic append method but hard coded the Regex Token to 12 columns. I didn't think about splitting to rows and then using cross tab - good idea!

Easy peasy, only 3 tools required.

Edit: Added Dynamic solution, equally easy 🙂

The solution file attached.

🙂