Describe the new feature

Please add support for Concordance DAT file delimiter/separators to the Import Table and Export Table features. Currently its impossible to correctly import these data files without manipulation.

Concordance is a litigation support application that uses a flat file database DAT files. It's a common format used in the litigation support industry/ legal information technology as a transport data load between clients, vendors, and the like. Sometimes these DAT files have to be fixed modified for various reasons and its far easier to do these sorts of changes in a database rather than a text file especially when these files can have millions of rows.

To my knowledge (and a I have looked) there are no other portable database(SQLite)/ database browsers (DB4S) that directly support the import and editing of Concordance DAT files. Access is prohibitive with it's limitations regarding field length, field names, required datatypes, max size, etc... SQLite is a much better option it costs nothing, it can be accessed with almost any programming language. Its data type affinities, in memory databases, encryption, etc...

There are several programs than can Load/Import a DAT file as a data payload but none of them have the ability to fix/modify the DAT files directly which is often required. This is literally the reason I'm requesting these feature(s).

Having DB4S support the import and export of DAT files would make it like a portable viewer and editor for DAT files. I hope one day they will replace the DAT files with a SQLite database which would make perfect sense for several reasons.

Below are programs that load/export DAT files and all of these are expensive production software. Literally almost all eDiscovery software will load or export a DAT file.

• LexisNexis Concordance
• LexisNexis LawPrediscovery
• ReadySuite
• Kcura Relativity
• IPro
• Summation

Here is a link that gives more information about the load file format (See Page 4).
LexisNexis Concordance Loading DAT File.pdf

Current Issues

1. The DC4 Control character "DC4" (ALT+0020) cannot be typed directly typed into the Field separator "Other" text box (see screenshot). You have to actually open a text editor or character map and copy the character and then paste it into the text field for it to allow it.

2. The Latin small letter thorn "þ" (ALT+0254) even though you are able to type this in its not recognized as a field separator and thus they are not stripped when you import the table(see screenshot).

Field Separator = ALT+0020 (DC4 Control) Decimal 20
https://unicodelookup.com/#dc4/1

Quote Character = ALT+0254 (Latin Small Letter Thorn) Decimal 254
https://unicodelookup.com/#254/1

Additional info

Please answer these questions before submitting your feature request.

Is your feature request related to an issue? Please include the issue number.

No

Does this feature exist in another product or project? Please provide a link.

No

Do you have a screenshot? Please add screenshots to help explain your idea.

Yes