Changes in this version:
-
Existing searching for duplicates has been replaced by more versatile functions:
- searching for duplicates either within the entire table or the current record set
- displaying the results using the physical table order or any sort order
- easy selecting up to 100 fields as a duplicate key
- displaying the results as:
the first (entered in the table) records from each group of duplicates,
the last (entered in the table) records from each group of duplicates,
all records from each group of duplicates except the first one,
all records from each group of duplicates except the last one.
-
-
Searching for/displaying all unique field values (incl. keys consisting of up 100 fields) and optionally saving their frequencies in another field.
Displaying the results as:
the first (entered in the table) records from each group of duplicates,
the last (entered in the table) records from each group of duplicates. -
Searching for fields values from any quartiles, below or above the mean. Searching statistical parameters can be calculated for the entire table or the current record set. For non-numeric fields the statistics is obtained as follows: string lengths for not formatted Text fields; numeric date/time values for Text fields formatted as Date/Time; the total size in bytes for Long Text and Images/Files fields.
-
In addition to fuzzy searches performed by the Find&Replace functions, the individual “Similar” field filter was added.
-
The “Hyperlink” field format has been extended to allow creating links and jumps between individual records in different tables.
The new “Copy As Hyperlink” copy command variant with the automatic Ctrl+C re-assignment simply creates and copies a given link that can
be then pasted in any record field of another or the same table. -
A new style to display a list of symbols/images entered in table fields as a list of predefined names.
For example, to display four-and-a-half out of seven-star ratings in a record field, you can enter:
star, star, star, star, star-half, star-empty, star-empty
10/11/2022 - 18.0.1 Update
- Significantly improved performance when using calculated fields in databases with large (e.g. hundreds of thousands, millions) numbers of records.