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 < tags and > as literal > 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 < tags and > as literal > 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 optional 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. |