How to manipulate text and values in a column using scripting

Sometimes it you'll want to change how the text or values are displayed in a table column. You can do some modifications straight in our dialogs, but by creating a small script you can do even more.
When editing a column in the editor, navigate to the expression tab. Here you can write your own custom code to do all sorts of great stuff.
Here is the basic script you need: