4/20/99: Uses improved QSort
Searches for duplicate records in a Table document based on user specified field(s). Either selects the duplicates or adds and calculates an identifier item. Also works on Shape fields! Click HERE for a version of "dup.ave" that uses 3.2's VTabSort class, which is more appropriate for large recordsets but will not support shapes.
4/20/99: Uses improved QSort
This script emulates ARC/INFO's FREQUENCY command. It generates a frequency table containing unique values of a field (or unique value combinations of more than one field) along with optional summary fields. Also, a case item may be added to the original table, allowing the frequency table to be joined to it. "Freq.ave" is designed to be called from another script: a sample front end script ("freqdlg.ave") is also included.
Note: The AV 3.1 report generator can create crosstab reports!
5/29/98
You can't directly modify fields in ArcView, but this script works around that by creating a new table and copying over the values. Allows you to rename fields, redefine them (e.g. change width or precision), and convert CHAR fields to DECIMAL and vice versa. The old .DBF file is given a .BAK extension and the table document recreated for the new file. Not recommended for use on Table documents created using FTheme.EditTable.
11/10/99: Updated for Version 3.2, export option added
Sorts a Table document by one or more columns, using 3.2's new VTabSort class. Each column may be sorted in ascending or descending order. If the sorted table is not to be exported to a new file, the underlying VTab must be editable because the script adds a temporary sort field. For the older version compatible with 3.0/3.1, see the "Oldies" page.
3/1/99
Returns a string corresponding to a unique temporary field name. For an example of its use, see SortTab above.
Return to
ArcView page