Challenge #28: Formatting Financial Data

[aclaxton]

Not the most elegant, but it works :)

Spoiler

[asabau]

Here is the workflow!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[maxjohnson02]

Solution attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Inactive User]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[daniel_ferreira]

Follow my solution attached...

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[KOBoyle]

Solution attached.

[KOBoyle]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ponraj]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JDelgado]

Interesting that there are RegexXXX() functions that you can use in a formula tool. Would have been a major PITA without it... lol.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[StevenBetts]

So I've included two solutions in my workflow. My first one is my first attempt and it's very... long. Then I had a look some other solutions and had a go at following the logic in those as well - this is my second, and more concise version 🙂

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.