Description

TdsTxtDataset is TDataset component to work with text files (browse and edit) whether that is file with delimiters or file with fixed length fields.

TdsTxtWizard is wizard just like the one that comes with MS Excel if you open text file. You define file type, delimiter or field lengths and field types.

Informations

• Status: Fully functional
• Source: On request
• Size: 430kB

Platforms: D2005, D2006, D5, D6, D7

Description

Access any text file as it were a table from a database. Indicate only the file, attach a DataSource and you may use any DataControl with it. Now, must of the methods of a regular DataSet are included, so you may add, delete, modify and filter records.

Field names and sizes may be defined on design or runtime, just before opening the file, or definitions may be stored on an schema file (even inside the data file).

Useful methods let you save the file with less fields, remove blank records, or saving the changed file in another.

Two classes are included and a sample:

• TSdfDataSet - for comma delimited files
• TFixedFormatDataSet - for fixed length files.

Informations

• Status: Fully functional
• Source: Included
• Size: 13kB

Platforms: CB5, D2, D3, D4, D5, D6

Description

The AsciiDataset is a VCL component with which you can access, edit, update a CSV file as if it was a table within a database.

TAsciiDataset features direct access to any CSV/SDF (comma delimited) file. You only need your EXE. You don't even need the CSV file if you defined persistant fields in your dataset, the CSV file will be created for you. The TAsciiDataset are compatible with any data aware component and CSV type file, thus a comma and quoted text file. Support for all fieldtypes from autoinc, strings, integer, floats,.., datetimes to enums, sets,..., memos and blobs.

TAsciiDataset is derived from TDataset and therefore includes all Standard Properties and Methods like MasterSource (connect to any other TDataset derived component MSAccess, DBase, etc) and MasterFields, Locate, LocateRecord and Lookup as well as full Bookmark support. Use of the TAsciiDataset is as easy as any TTable.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $49
• Size: 1 034kB

Platforms: D2005, D5, D6, D7

Description

TFieldedText enables CSV files (and other text files containing tables of values) to be read and written in a similar fashion as database tables.

The approach is quite straight forward. You provide a small XML file which defines the Meta structure of the information in the text file. TFieldedText uses that to read from and write to the text file as if it were a database. Typically you would use a Fielded Text Editor to create these Meta XML files.

The format (schema) of this Meta XML file is specified by a standard defined at this site. In addition to using these Meta XML files, TFieldedText can also be used to create them. These XML files can then also be used by any other software component/library which support this standard.

TFieldedText can be used to parse or generate nearly any type of CSV and Fielded Text file. This includes files which have:

• fields are separated by delimiters (eg CSV files).
• fields which are fixed length.
• fields that are quoted.
• fields that have new lines embedded in them.
• headings.
• substitutions.
• lines with different sets of fields based on key fields.
• more...

This release is for Delphi versions up to XE4. For later versions of Delphi, use release 2 or later of TFieldedText.

Informations

• Status: Fully functional
• Source: Included
• Size: 104kB

Platforms: DXE, DXE2, DXE3, DXE4, DXE64

Description

A component for all who want to access CSV files with Delphi's database components. TLbCsv links to TDataSource just like a TTable, and can be used just the same. Fields are always strings, 255 chars wide. No memo/blob support. Filtering doesn't work yet, networking support will never be included, and the component is in beta state, but it works.

Informations

• Status: Fully functional
• Source: Included
• Size: 3kB

Platforms: D3, D4, D5, D6