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