Extract and sort rows (Extract)

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.

Extract tab

In the extract table, you can click on the row number (underlined) to return to the row of the source table.

Column

You have to select the column from which you want to extract the rows.

Condition

You must select the conditions to be applied for the extraction of the lines (eg greater, less, equal, contains text, begins with, ends with ....).

Value

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.

Add

The button allows you to add other fields for the search.

Clear all

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.

Total row

If the function is activated, the program displays the total for the extracted rows that have an amount or a time counter.

Sort tab

The sorting columns are indicated. The options are the same as the Sort rows commands.

Customization tab

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