||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"
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