GET TRANSLATE

GET TRANSLATE reads dBASE files, Excel files prior to release 5, Lotus 1-2-3, Symphony, and Multiplan files. To read more recent version of Excel or text data files, use GET DATA.


GET TRANSLATE FILE=file

 [/TYPE={WK }]
        {WK1}
        {WKS}
        {SYM} 
        {SLK} 
        {XLS}
        {DBF}
        {TAB}
       
  [/FIELDNAMES]*
 
  [/RANGE={range name }]*
          {start..stop}
          {start:stop }

  [/KEEP={ALL**  }] [/DROP=varlist] 
         {varlist}

[/MAP]

*Available only for spreadsheet and tab-delimited ASCII files.

**Default if the subcommand is omitted.

Table 1. File types
Keyword Type of file
WK Any Lotus 1-2-3 or Symphony file
WK1 1-2-3 Release 2.0
WKS 1-2-3 Release 1A
WR1 Symphony Release 2.0
WRK Symphony Release 1.0
SLK Microsoft Excel and Multiplan in SYLK (symbolic link) format
XLS Microsoft Excel (for Excel 5 or later, use GET DATA)
DBF All dBASE files
TAB Tab-delimited ASCII file

Syntax for the GET TRANSLATE command can be generated from the Open File dialog when selecting one of the file types listed above.

Example

GET TRANSLATE FILE='PROJECT.WKS'
 /FIELDNAMES
 /RANGE=D3..J279.