<< Click to Display Table of Contents >> Navigation:  Reference Manual > Windows and dialog boxes > Raw CSV file view > Raw CSV file view menu

This is the menu for the Raw CSV file view window.

File

Used for opening, saving and closing files:

IMPORTANT: To save the viewed data in a new sorted order you extract the file and then use Save as.

Open

Close the file currently being viewed and open another:

•CSV file - the program will scan the front of a CSV file to determine the character used as the delimiter

•Excel workbook

•Unicode TXT file (uses tab character as the column separator)

•Simple XML file

Worksheet select

If the file you opened is an Excel workbook with more than one worksheet, this opens Raw CSV file treatment to select a particular worksheet to view.

If the file you opened is an XML file with more than one level (tier) of data this opens Raw CSV file treatment to select the table to view.

Treatment and separator select

This opens Raw CSV file treatment to change the way the CSV file is read.

Save

The file is saved with any changes and a copy is kept in the Archive sub-folder.  Only changes to the data will be used when saving, the order is unchanged even if the view has been sorted.

Save as

The changed file is saved.

Exit

Close the window.  You will be prompted if the file has changed

Edit

Used to change the contents.

Rename columns

Used to alter the headings of the columns with Rename columns.

CSV files used with the program usually need set names as the headers, for example "Serial" or entry names used in the project.

Delete columns

Used to delete columns with Delete columns.

Over-typing allowed

To prevent accidental changes you must set this before you can change individual cell contents.

Insert and delete line allowed

To prevent accidental deleting of whole rows you must set this before you can delete lines.

This setting also causes the new row to appear at the bottom of the list so that new rows of data can be added.

Copy whole view to clipboard

This copies the whole data to the clipboard as viewed including any reordering of columns or sorting of rows.

Whole view extract

Opens a new "Raw CSV file view" window with the data as viewed including any reordering of columns or sorting of rows.

Extract part of view

Allows selected parts of the data to be viewed in another Raw CSV file view window using Data extract. Extended facilities licence needed.