ACL™ – Help­ful Keys (Script­ing)

Most analysis programs offer the possibility of scripting in addition to the wide range of functions and commands. The scripting languages list here the sequence of commands and thus form the basis of standardization. Another great advantage of scripts is the enormous execution speed compared to manual processing. The script development requires some experience with macros or other sequential programming languages. In order to facilitate certain aspects, such analysis software like ACL ™ provides useful buttons in the script editor. In addition this "Function-Keys" can also be used in the filter and command line. In this post the "Function-keys" of ACL™ are explained briefly.

Insert Fields (Key „F2“)

We are now in the script editor of ACL ™ and create, with the help of the Function-keys. a few lines of code.

Screen 1 – Script Editor - "F2"

With this function, you can access all fields of the open table and add for example in a "Extract" command the selected fields. On the right side you can selectively restrict the data types of the fields to find the desired field faster.

Screen 2 – Script Editor - "F2" Result

Insert Project Item (Key „F4“)

Screen 3 – Script Editor - "F4"

All content / elements of this ACL project can be integrated with the key "F4" in the script. So you can select and insert table layouts, scripts, views, workspaces, and indexes. This can avoid typing errors, or calling non-existing elements.

Screen 4 – Script Editor - "F4" Result

Date and Time Selector (Key „F8“)

Screen 5 – Script Editor -"F8"

In ACL ™ the date is displayed with the format "YYYYMMDD" and also enclosed with reverse single quotes. This particular form of representation is generated directly from the system, if the date is inserted with the key "F8".

Screen 6 – Script Editor - "F8" Result

The date has now been inserted without much effort in the correct format.


When using these keys, you can speed up scripting and avoid errors that can be caused by manually entering. How do you specifically created scripts and what functionality ACL ™ delivers, I will describe in the next few weeks in a blog post.

Best Regards
Florian Popan

P.S. For any comments or questions, feel free to write us at info@dab-gmbh.de.

Comments (0)
Be the first who comments this blog entry.
Blog login

You are not logged in. Please log in to comment this blog entry.

go to Login