Double Clicking DB Field Name

Can also be selected with Stats button on table display window but in that case you have to select the field.

• Field statistics (min, max, mean, median, etc.)
• Histogram
• Sum
• Longest string 
• List unique values
• Count unique values
• Frequency table
• Count of records with substring: gives a count of the number of records that contain the substring.
• Sort field: for numeric fields only, this produces a popup with the values in the field sorted.  For string fields, use list unique values.
• Edit
  • Search and replace: replace one string with another, only for string fields.
  • Fill field--place the same value in all records.  If the database if filtered only the current subset will be operated on.
  • Color all records: if there is a COLOR field, you can fill it for all selected records with a single color.   By changing the filter you can get several colors.
  • Change field type
    • Integer to string
    • String to integer, only if the length of the field < 12 since DBF files do not handle very long integers
  • Rename field
  • Delete field
  • Trim field length: some databases have really long fields, usually for strings, and often use only a tiny fraction of the allocated length.  This makes it hard to see any other fields.  If you trim the field to the length of the longest record, it can be much easier to manipulate the database.  However, if you want to later edit the field values, you cannot increase the length.
  • Limit decimal places: if there are too many decimal places, you can pick a reasonable number which makes viewing the data easier.
  • String manipulation
    • Remove lower case characters
    • Remove numerical characters
    • Remove final character
    • Remove entire string if substring present
    • Remove substring and following characters
    • Trim blanks
    • Alphabetize: must be strings separated by commas
    • Add file extension: pick a file extension, and if the string does not end witht that extension, it will be added to the field.
    • Extract file name
• Find
• Hide: the field
• Sort table: sorts entire table based on this field.  This will create an MDX file to go with the database.  You can purge these when the data closes if you choose to pick the option on the Database tab of the options form.
• Quick filter
• KML export filtered by values

Last revised 7/19/2022