Governor Phil Murphy • Lt. Governor Tahesha Way
  Search
new jersey department of environmental protection
NJ Home Page Services A to Z NJ FAQs NJ Departments/Agencies departments
site remediation program

SRP Home | DEP Home

Guidance DocumentsSRP-EDI Manual6.0 Submittal in Text Tab Delimited Format

 

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

  1. Produce the DTST, HZSAMPLE, and/or HZRESULT file in Excel.
  2. Go to the Main Menu and select FILE.
  3. In the File Menu, select SAVE AS.
  4. Go to the box entitled SAVE AS TYPE, select Text (Tab delimited) (*.txt).
  5. Go to the box entitled FILE NAME and type in the appropriate name for the file.
  6. Click on the SAVE button.
  7. If the active Excel Workbook contains more than one spreadsheet, follow the directions for saving each spreadsheet under a different name.
  8. 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