<< Click to Display Table of Contents >> Navigation:  Reference Manual > Windows and dialog boxes > Data extract > Data extract

Extended or CATI licence

From the "Raw CSV file view" window use [Edit] [Extract part of view].

This is used to obtain part of the data from a CSV file.  The extracted data can then be saved to another file, copied to the clipboard, or further extractions can be made.

The original file is not altered; a copy of the relevant data is used.

You can:

•You can choose to extract only rows that contain a certain value in a particular column.

•You can sort the rows on a particular column.  This uses a mixed sort.

•You can exclude all columns that begin with a certain character or string of characters.

•You can also select one or more individual columns to extract.

•You can remove all duplicate rows from the extracted data.

The data you have selected is shown in a new "Raw CSV file view" window.  The data has been copied for this new window; changes to this new window will not alter the original contents.

You can extract the data again from the new window, for example to apply a second row filter or a second sort order.