Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > G > GATEWAY

EXPORT

Scroll Prev Top Next More

Specifies that you want to export an R:BASE table or view to an external file.

 

GATEWAY_Export

 

Options

 

filename

Specifies the name of the file to export to.

 

OPTION

Specifies an additional parameter for the output. Options listed may vary based upon selected format. You must Use the pipe "|" symbol to separate OPTION parameters if more than one parameter is used.

 

ACTION

ACTIVE_INDEX

ADD_UTF8_BOM

BLANK_IF_NULL

BLANK_IF_ZERO

COL_NAMES

DATASET_FIELD_ORDER

DETECT_FORMULA

EXTRA_SHEETS

FOOTER_TEXT

FORMAT

HEADER_TEXT

HTML_PATERN

LAYOUT

MESSAGES

NAMED_NUM

NAMED_TEXT

NO_UNICODE_CONVERSION

PASSWORD

PASSWORD_TO_OPEN

QUALIFIER

RAW_GEN

REC_SEP

ROWS_PER_FILE

SEPARATOR

SHEET_INDEX

SHEET_NAME

SHOW_PROGRESS

SPECIFICATION_FILE_NAME

STRUCTURE

STYLE

TAB_NAME

TABLE_NAME

TITLE

WRAP_TEXT

 

SELECT clause

Specifies and limits rows of data using the SELECT command.

 

type

Specifies one of the following codes for accepted file formats:

 

Code

Details

DB

Paradox

DBF

DBASE

CSV

ASCII File, Delimiter Comma, Qualifier Double Quote

FIX

ASCII File, Fixed Width

HTM

HTML

XLS

MS Excel Spreadsheet

XLSW

MS Excel Workbook

DOC

MS Word

TAB

ASCII File, Delimiter Tab, Qualifier None

SLK

SYLK Symbolic Link

DIF

DIF Data Interchange Format

WK1

Lotus 1_2_3

WQ1

QuattroPro

SQL

SQL Script

XML

XML

CLBR

MS Windows Clipboard

RTF

Rich Text Format

SAV

SPSS Format

PDF

Adobe Acrobat Portable Document Format

LDIF

LDAP Data Interchange Format

JSON

JavaScript Object Notation

ODT

OpenOffice Text Document