Every time I work with it, I love IronPython in Select, it is clearly a replacement for most of what happens in formulas. I wrote an introductory piece a few months back. I then took the concept of Document Formatting Options, like LD and LDR to control how date fields render to built an IronPython module that emulates most of the Document Formatting Options available. I added a couple more like Pad left or right with any character.

If you or someone you know is interested in learning about IronPython this tool would be an excellent starter for setting system default values.  It provides an easy way to create automated legal descriptions, mortgage clauses, or any other text based field. It handles formatting of data allowing the developer to easily add information. The entire set is over 500 lines of code and includes examples of automating the values for escrow brief legal and existing liens.  At the end of this article, I’ll include the output from the test tool. The test tool is also included in the package as a source of examples.

Continue reading →