6.0 Submittal in Text Tab Delimited Format
It is possible for the user to save and
submit these files in a "text, tab-delimited"
(i.e., ASCII, tab-delimited) format, rather than saving
and submitting the DTST, HZSAMPLE, and HZRESULT files in
either .DBF or .WK1 formats. Users should be aware that
the SRP is planning on accepting only ASCII, tab-delimited
submittals in the near future.
Users should continue to create the DTST,
HZSAMPLE, and HZRESULT files in whichever spreadsheet or
database application they are currently using; the files
are to be created as described in Sections
3.0 and 4.0 of
this manual. There is no difference in data content requirements
when saving in this "text" format compared to
the .DBF or .WK1 formats. As the final step before exiting
the application, the file(s) should be saved in the ASCII,
tab-delimited format.
Each spreadsheet and database application
may have a different procedure for saving files in the ASCII,
tab-delimited format. In general, go to the application's
"SAVE AS" command, go to "FILE TYPES,"
and select ASCII (some applications may refer to this as
"TEXT, Tab Delimited" rather than "ASCII,
Tab Delimited"). The "tab-delimited" selection
will usually be available as a FILE TYPE on the SAVE AS
dialog screen. An example of this procedure is given below
for saving from Microsoft Excel. If you use different software,
or have questions regarding this procedure that are specific
to your software, please contact your software vendor or
manufacturer.
EXAMPLE: Saving Spreadsheet Created
In Excel As ASCII, Tab Delimited
- Produce the DTST, HZSAMPLE, and/or HZRESULT file in
Excel.
- Go to the Main Menu and select FILE.
- In the File Menu, select SAVE AS.
- Go to the box entitled SAVE AS TYPE, select Text
(Tab delimited) (*.txt).
- Go to the box entitled FILE NAME and type in
the appropriate name for the file.
- Click on the SAVE button.
- If the active Excel Workbook contains more than one
spreadsheet, follow the directions for saving each spreadsheet
under a different name.
- When done entering information, make sure to again save
the file in the Text (Tab delimited) (*.txt) when quitting the application.
It is strongly recommended that the ASCII
(.TXT) files be reviewed prior to submittal to the SRP,
to verify the file contents. The files can be reviewed using
any text-editing software. The programs NOTEPAD and WORDPAD
are available as part of all Windows 95 and Windows 98 installations.
Do not be alarmed by what appears to be misaligned columns.
Many text editors will present the tab-delimited data in
this manner.
|
Alternate Format of the Entire Guidance Document
Help
for Using Files |