Mini-scripts differ from the larger category of "Scripts" in that they are generally used as part of another script or are designed to do a short simple task.  In other words, while these scripts are designed to work on their own, they are really intended to be part of a larger script.

---

Name of Script:  Add Header
Script Writer: Porter Broyles
Brief Description: Occasionally when requesting data from somebody else, the data received will be provided without a header and a separate file will contain the field names.  These names have to be entered manually.  This script was written to automate that process.

---

Name of Script: Alphabetical Order
Script Writer: Porter Broyles
Modified version: David Coderre
Brief Description: In Feb 2009, a challenge was placed on the ACL user forum looking for a way to alphabetize the order of the letters in a field.  Eg take "Porter Broyles" and give the result of "BEELOOPRSY".  The attached is a the code along with a short explanation as to why it works.

---

Name of Script: Calculating Working Days Between Two Dates

Script Writer: Porter Broyles (derived from article in Take Command.)

Brief Description: This code is designed to calculate the number of working days between two days.

---

Name of Script:  Display Menu
Script Writer: Ian Craigen
Brief Description:  This adds a menu of display commands under the applications menu.  This is an excellent example of how to utilize the Application Menu.  Ian is one of the top ACL contributors to the ACL User Forum.

---

Name of Script:  Easter

Script Writer: Ian Craigen
Brief Description:  Ian took the challenge to write a code to calculate Easter.

---

Title: First and Last Date
Author: David Coderre
Summary:  This code was shared on the ACL User Forum in 2006 or 2007.  This code is designed to isolate and extract the first and last records of a file based upon the date.  It is not an interactive script and adaptions are necessary.

---

Title: First and Last Record
Author: David Coderre
Summary: This code was shared on the ACL User Forum in 2006 or 2007.  This code is designed to isolate and extract the first and last records of a file based upon the way the file is currently sorted.  It is not an interactive script and adaptions are necessary.

---

Title: Flatten Files
Author: David Coderre
Summary: David Coderre provided the following code as an alternative to using the RECOFFSET command on the ACL User Forum.

 

---

Title: Gaps in Sequence

Author: Porter Broyles

Summary: This code was designed to identify gaps within sequences.  In otherwords, given a key field, there should be a numeric sequence.  This code identifies cases wherein the sequence is not numeric on a given key field.

---

Name of Script:  Headers to fields
Script Writer: Porter Broyles by way of ACL (Heiko Weiler)
Brief Description: On occasion one will want to have access to tall of the field names on a table.   This is an adaptation of the code provided by Heiko Wieler formerly at ACL.  It will identify all of the fieldnames on a table and put them into a new table that can then be used for various purposes.

---

Name of Script: Holidays
Script Writer: Porter Broyles
Brief Description:  This code is the basis for automating holidays at a company or corporation.  It is intended to minimize the need for updating holidays annually.

 

---

Name of Script: Running Totals
Script Writer: Porter Broyles (originally inspired by ACL's support site.)
Brief Description: Running totals are when you add the value from a current field with the cumulative value of the previous numeric fields.

 

---

Name of Script:  Running Totals with Breaks
Script Writer: Porter Broyles (originally inspired by ACL's support site.)
Brief Description: Running totals with breaks are when you add the value from a current field with the cumulative value of the previous numeric fields, but wherein you start the running total over when you change product, department, or some other key piece of data.

 

---

Name of Script:  Summary Reports
Script Writer: Porter Broyles
Brief Description: The summary report is a short report that summarizes the results of a project with multiple outputs.  This is particularly valuable when utilizing continuous monitoring projects.

---

Name of Script:  Time between times
Script Writer: Porter Broyles
Brief Description:  ACL doesn't handle times very well.  There is no code designed to take a start and stop time, and compute the time between them.  This code is designed to do just that, given a start and stop date, and start/stop times in a HH:MM:SS format.

---