Type: Duplicate Search
Name of Script: Q-Grams
Script Writer: Porter Broyles
Brief Description: This code is an advanced adaptation of David Coderre's Fuzzy Duplicates script. It is, however, a significant enhancement upon the original as it looks for similar strings within a certain range of the original.   NOTE:  Please be aware of the following.  The code was written as a supplement to a traditional duplicates search.  In order to eliminate true duplicates, a trap was added to the code.  If you want to run the code in a manner that it captures true duplicates, get rid of the marked through section.  It appears twice in the code.

This was a more advanced version of the above script.   You should double check to see if it has the same problem mentioned above.

Type: Duplicate Search
Name of Script: Levenshtein Distance
Script Writer: David Coderre
Brief Description: David Coderre wrote on the ACL User Forum: "Levenshtein Distances script uses a fantastic algorithm (developed by Levenschtein) for determining how close two strings are to being the same (distance of 0 is identical; distance of 1 is one keystroke - either one missing or one different character); however, it is very slow - about 2 seconds per record."  This script was Dave's 1000th post on the ACL User Forum. 

Type: General Application
Name of Script: Append ALL
Script Writer: Porter Broyles
Brief Description: This script is designed to append any number of files into one file.  It will normalize that data including field type and field length.  This script was Porter's 1000th post on the ACL User Forum.

 Type: General Application
Name of Script: Append All New
Script Writer: Porter Broyles
Brief Description: This script is designed to append any number of files into one file.  It will normalize that data including field type and field length.  This script is much shorter and more user friendly than the older version.  It is also quicker than the original version, but can still be time consuming when dealing with numerous files.

Type: General Application

Brief Description: This code was written to create various possible combinations of data.  In other words, suppose you have 30 items for sale at a store.  You are going to purchase 4 items, but you don't know which four.  There are 30*30*30*30 possible combinations of items you can purchase.  This code will create all 810,000 possible combinations.

Type: General Application

NOTE:  While the code asks for Invoice, PO, Voucher you can select any 3 fields so long as they are character fields.

Type: General Application
Name of Script: Preserve Variables
Script Writer: Porter Broyles
Brief Description:  This script is a proof of concept script.  It was written as an alternative to using global variables.  The script is designed to preserve variables from one session to another.  By using this script, one can utilize the best practice of "DELETE ALL OK" at the start of scripts.

Type: General Application
Name of Script: Ultimate Table Compare
 

Type: General Application

Script Writer: Porter Broyles
Brief description: Suppose you have written a large script that loads a number of files directly into ACL.  As part of your validating the results, you want to create an ACL file to verify the validity of the data in each of the tables.  This code was written to create a .fil table that contains the table that was being reviewed, the number of errors identified, the record on which the error occurred, and the field name identified.

 Type: General Application

Script Writer: Porter Broyles
Brief description: This script is designed to be usable to check the version of ACL being used as compared to the version of ACL project the script was written on.  If the version is use is older than the version the script was written on a warning will be provided to the user that some commands may not be compatible.  This script will also verify that the version is greater than 9.1 if the project will be loading a pdf file (an option only available on version 9.1 or greater.