This function is available vie the Data → Extract and sort rows menu ...
Contrary to the Sort rows command, the program creates a separate table where the extracted rows are displayed. Therefore, the rows of the main table are not changed.
In the extract table, you can click on the row number (underlined) to return to the row of the source table.
You have to select the column from which you want to extract the rows.
You must select the conditions to be applied for the extraction of the lines (eg greater, less, equal, contains text, begins with, ends with ....).
In this field it is necessary to enter the text to be used as a comparison, in relation to the condition (for example, if the condition is = equal, entering 25.01.2022 as the comparison value, the program extracts all the transactions with the date 25 January 2022).
The text is a date if the chosen field is Date, a numeric value if the field is an Amount, a word if the column is a Description.
The button allows you to add other fields for the search.
The button allows you to delete the settings chosen for data extraction in the various lists.
Selected rows only
This option is active only when rows have been previously selected and allows the sorting of the selected rows.
If the function is activated, the program displays the total for the extracted rows that have an amount or a time counter.
The sorting columns are indicated. The options are the same as the Sort rows commands.
Explications for this window are available on the following web page: Customization.
Account list example
It sometimes happens that you require a list containing only the accounts:
- Go to the Accounts table.
- Select Extract and sort command.
- Select Account in the the columns box
- Select Not empty in the the conditions box
If you want to extract the accounts sorted by description:
- Select Order section
- Select Order by button and select Description
If you want to display only certain columns, you can create a new view with the Tables setup command.