1-2-3 IMPORT NUMBERS (.002)    FOREIGN FORMAT (.44)

Name Value
NAME 1-2-3 IMPORT NUMBERS
FIELD DELIMITER 032
SEND LAST FIELD DELIMITER? YES
SUBSTITUTE FOR NULL 0
DESCRIPTION
This format exports data for use with LOTUS 1-2-3 spreadsheets.
Non-numeric fields will be in quotes.  Each field will be separated by
a space.  Null-valued numeric fields in the primary file will be converted
to a zero ('0'). WARNING: If the value of a field that is not in the
primary file or that is not defined in the VA FILEMAN data dictionary as
numeric is null or zero, nothing is output. That is, a zero (0) is NOT
output.  This will destroy the positional results of the data and will
install data in incorrect columns!!  If this situation is possible, do NOT
use this format; consider the 123 DATA PARSE format.
USAGE NOTES
To import into 1-2-3, choose FILE->IMPORT->NUMBERS.
Field values will automatically be placed into columns.
Lotus 1-2-3 will automatically recognize your file for import if it has an
extension of '.PRN'.
FORMAT USED? YES
OTHER NAME FOR FORMAT
  • LOTUS 123 (NUMBERS)
MAXIMUM OUTPUT LENGTH 0
QUOTE NON-NUMERIC FIELDS? YES
PROMPT FOR DATA TYPE? YES