General Options

PdxEditor export

Field separator in text export

Comma, Semicolon or Tab Character

String Quoting

Optional Quote (double quote = ") when exporting using Comma or Semicolon.

Character Coding in text export

ANSI character set dynamically interpreted according to current system settings or fixed UTF-8 coding including Byte Order Mark (BOM).

Character coding of exported text file valid for all text containing exported fields.

Paradox Field Type

Equivalent

Exports

Alpha

VARCHAR

Yes

Export according to language driver of selected table.

Number

FLOAT

Yes

Decimal character according to the current system settings.

Money

CURRENCY

Yes

Exported as FLOAT, currency descriptor not included.

Short

(16-bit integer)

SMALLINT

Yes

Exported as INTEGER.

LongInteger

(32-bit integer)

INTEGER

Yes

Exported as INTEGER.

BCD

(Binary Coded Decimal)

Yes

Exported as FLOAT.

Date

Yes

Date format according to current system settings or optionally the universally accepted ISO format (YYYY-MM-DD).

Time

Yes

Time format according to current system settings.

TimeStamp

Yes

DateTime format according to current system settings or optionally the universally accepted ISO format (YYYY-MM-DD hh:nn:ss).

Memo

BLOB(n,1)

Yes/Yes

CSV/Text: Exports as single line to keep within one line records.

Line breaks are exported as literal <br> tags, Tab characters as literal <TAB> tags, quotes (") as "", and optionally < as literal &lt; tags and > as literal &gt; tags.

Excel: If the Memo contains RTF-coded text, this will be converted to plain text. Line breaks optionally converted to '<br> ' tags.

Individual cell export: Each Memo may be exported as an independent entity via the popup editor evoked via the data grid cell, as simple text file (.txt) if plain text, and as RichTextFormat document (.rtf) if the contents is rtf-formatted.

FormattedMemo

BLOB(n,3)

Yes/Yes

CSV/Text: Exports as single line to keep within one line records and including RTF-codes.

Line breaks are exported as literal <br> tags, Tab characters as literal <TAB> tags, quotes (") as "", and optionally < as literal &lt; tags and > as literal &gt; tags.

Excel: RTF-coded text converted to plain text. Line breaks optionally converted to '<br> ' tags.

Individual cell export: Each FormattedMemo may be exported as RichTextFormat document (.rtf) via the popup editor evoked via the data grid cell.

Graphic

BLOB(n,5)

No/Yes

CSV/Text/Excel: Non empty source fields marked as '<Graphic>' in exported text file or Excel file.

Individual cell export: Each graphic may be exported as independent entity from the popup viewer evoked via the data grid cell. Export will be in the format of the originally imported graphic (png, jpeg, gif, tiff, bmp or ico).

OLE

BLOB(n,4)

No

Non empty source fields marked as '<ParadoxOLE>' or '<DBaseOLE>' (depending on source file format) in exported text file or Excel file.

Logical

BOOLEAN

Yes

CSV/Text: Exports as "True"/"False"/blanks
or optionally as 1/0/blanks.
Excel: Exports as "True"/"False"/blanks.

Autoincrement

(32-bit integer)

Yes

Exported as INTEGER.

Binary

BLOB(n,2)

No/Yes

CSV/Text/Excel: Non empty source fields marked as '<Binary>'/'<TypedBinary>' (dBase) in exported text file or Excel file.

Individual cell export: Each binary may be exported as independent entity from the popup dialog evoked via the data grid cell. If exported the binary is saved "as is" without associated information of file type originally imported. To save information on impored binarys it is recommende storing this in a text cell (VARCHAR) next to the binary cell.

Bytes

Yes

Bytes are exported in text files as well as to Excel as hexadecimals.