Atn()

Brian Element

Calculates the value containing the angle whose tangent is the specified number.  The result is a double type.  The example below calculates pi.

2nd - 3rd - 4th digit test

Brian Element
Background

This script will perform the 2nd, 3rd and 4th digit test which is based on Benford's Law.  The test is based on Mark J. Nigrini's book Benford's Law Applications for Forensic Accounting, Auditing, and Fraud Detection.  The script will create one file for each digit test.

Feb 14, 2013 - Updated for IDEA v9.

Identify Blank / Repeat Fields

Brian Element
Background

This script will identify any blank fields or fields in which the information repeats.  The scrpt will rename the fields based on a prefix that the user gives.  It also write a text file to the working directory of the fields which should be kept.  The script will then create a new IDEA file which will list the fields that contain empty or repeating data and allows the user to decide if they wish to keep or delete the field.  The user would then run the script a second time in order to delete the choosen fields.

Replace function

Brian Element

This function allows you to replace part of a string with another part.  So if you have a string "ACBDEFGH" and you want to replace "DEF" with "MNO" using this function it would return "ABCMNOGH"

Subscribe to