Skip to main content

Identify Blank / Repeat Fields

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

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"