Next: 10.1.7 Importing Text Files
Up: 10.1 Importing Data into
Previous: 10.1.5 Importing Data from
NExS gives you additional control on importing or pasting
text into the spreadsheet using the Import Options dialog
window. These options determine how the contents of the
text file is parsed and placed in cells.
To change import/export options:
- Select Import/Export Options... from the Options
menu to display the Import Options dialog box as shown in
Figure 10.1.
- Select from the following options:
- One Word Per Column -
-
Allows you to import a text file where
blank spaces in the file are used as
delimiters. Text strings are imported as
text and numbers are imported as numeric
values. A string or a value is placed in
each corresponding cell.
- Whitespace Threshold -
-
This option allows you to indicate what
percent of all lines must have a blank in
the exact same location for that location
to be recognized as a field delimiter. The
extreme cases (0 and 100) have the
following properties:
- 0 -
- The import creates only one column;
the entire text of the line goes into
the cell.
- 100 -
- In order for a column to be defined,
a blank must be in the same relative
position in every row.
- Auto-escape LaTeX special characters -
-
When enabled, characters embedded in text strings
which are special to LaTeX, such as ``$'' and ``%''
will automatically be converted to their proper
escape sequences when cells are exported in LaTeX
tabular format. This mode will produce correct LaTeX
translations for most ISO-Latin1 character codes,
as well. When disabled, the user is responsible for
embedding the proper escape sequences in the cells'
text strings. (The disabled mode is generally only
useful for producing LaTeX-specific content in an
exported cell, such as a mathematical formula.)
- Reset to Defaults -
- Restore default settings.
Figure 10.1: Import Options Dialog Box
Next: 10.1.7 Importing Text Files
Up: 10.1 Importing Data into
Previous: 10.1.5 Importing Data from
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999