- To save the contents of a spreadsheet as an ASCII text file select File | Save As then choose the File Type as Text File (*.txt) from the dropdown list.
- Click Options. This lets you control how the text file is written (see below).
Maximum line width
This sets the maximum number of characters that can be written to any line of the file. Any row of the spreadsheet that requires more characters than specified will be wrapped, to form multiple lines in the text file. You may need to set the maximum width if you wish to read the data into other programs or output to the printer. In particular, reading data in Genstat using commands assumes a width of 80 characters unless specified otherwise in the OPEN statement.
If selected, this will add a Genstat-style comment, enclosed in double-quotes (“) at the start of the file.
If selected, this will include a row at the top of the file indicating the names of each column.
If selected, this will enclose strings in single-quotes (e.g. ‘A’).
If selected, a colon (:) will be written at the end of the file.
Output values with full precision
If selected, the values in a column will be output with 15 significant figures (full precision), otherwise the values will be output as displayed in the spreadsheet with potential rounding of the values and subsequent loss of precision.
Align columns with spaces
If selected, spaces will be added to column values so that all of the column’s values are vertically aligned, otherwise no spaces are added. Note that if spaces are added to values this may make the file incompatible with other applications.
Include data type indicators on column names (!, # and $)
If selected, the column names will have type indicators (! for a factor, # for a variate and $ for a text) appended to the name, otherwise just the plain column names with no decoration will be output.
Separate data columns using
Specifies how to separate the columns of data within the file. You can use either a space, tab, or comma.
|Clear||Clear all fields and list boxes.|
|Help||Open the Help topic for this dialog.|
To produce an ASCII data file suitable for loading via the Load ASCII File menu a suitable combination of options is: Comment Line, Variable Names, Quoted Text, Maximum Width 200.