1-2-3 DATA PARSE (.001)    FOREIGN FORMAT (.44)

Name Value
NAME 1-2-3 DATA PARSE
SEND LAST FIELD DELIMITER? YES
FILE HEADER W $$DP123^DDXPLIB(DDXPXTNO)
DATE FORMAT S Y=$E(X,6,7)_"-"_$P("JAN^FEB^MAR^APR^MAY^JUN^JUL^AUG^SEP^OCT^NOV^DEC",U,+$E(X,4,5))_"-"_$E(X,2,3) S:$E(X)'=2 Y="NOT 1900s"
DESCRIPTION 
This format produces fixed length records designed for import into Lotus
1-2-3.  The user is prompted for data types.  A special header is created
that is used by 1-2-3's Data Parser.  The maximum record length is 240
characters.
USAGE NOTES 
To import data into 1-2-3 from a file created with this format: 1) Use
make the date readable by using Range->Format->Date.
File->Import->Text and select the file.  2) The first line of the file
contains the information for the data parser.  You must change this from a
label, preceded by ', to a format, preceded by ||.  Edit the line to make
this change.  3) Use Data->Parse.  The Input Column range should include
all the imported data, including the format line.  Select a desired Output
Range. Finally, select Go to format the data in the output range. Be sure
your columns are wide enough to hold the data.  NOTE: dates will be
changed into numbers, 1-2-3's internal representation of a date. You can
FORMAT USED? YES
RECORD LENGTH FIXED? YES
OTHER NAME FOR FORMAT
  • Lotus 1-2-3 Data Parse
MAXIMUM OUTPUT LENGTH 240
PROMPT FOR DATA TYPE? YES