flex your data

The gist for this pattern can be found here. The goal Sometimes we might have numbers in a text file formatted like this: I’d like to create a custom column that converts this text into a currency data type, preserving the scale of the suffix in each row and preserving the currency symbol. A solution I say “a” solution, because I’m sure there are many others. Here’s a snippet we can paste into the Advanced Editor. Alternatively, we can just paste lines 2 through 41 into a Custom Column dialog. I know, it looks long, but I’ve put a lot…