PdxEditor Export Specification


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
Exports as TRUE/FALSE or 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>' 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
No
Non empty source fields marked as '<Bytes>' in exported text file or Excel file.