Challenge #234: Spell It Out For Me - Part 1

[AYXAcademy]

A solution to last week’s challenge can be found here. Source: https://www.mashupmath.com/blog/expanded-form-with-decimals

This week's challenge is a two parter that will include a follow up challenge next week. For now, we dig into part 1!

If you've ever worked with continuous variables in Designer, you may have noticed that the values are left justified in the Results Window. This can make it a little more difficult to read your dataset. Convert the values provided into a table that lines up the decimals and has only one character per cell.

[robert-headington]

This will work for any set of numbers that has no more than 2 d.p and is no more that 999999999.99. I could have made it more adaptable but I thought that would be overkill for currency.

[Toons]

My solution :

Spoiler

[jamielaird]

Here's my solution:

Spoiler

[JP_SDAK]

Love the tokenizer!  Sounds like a super hero

Spoiler

[apathetichell]

Now off to browse everyone elses solutions to see if there was some two tool solution which I skipped... Is there an issue with some versions processing fixed decimal types? I know there was a question on the forum a few weeks back from a user who couldn't get two decimal places automatically using a fixed decimal with a detail of 2.  My version of Designer seems to have the same issue so I had to manually add the extra zero where applicable.

[SWalker]

Lil Pad action & Regex. 

[MPard]

Spoiler

Found an elegant 3 step solution for this one!

[bjkay30]

I struggle to find a use-case where needing to do this would actually be beneficial.  However, good use of the "Padleft" function.

Spoiler

[PeterYuan]

Spoiler

learn about Padleft function

[DataHabanero]

Excellent challenge, really fun!