Re: Tex file import

From: "Bill Todd" <no@xxxxxx>
Date: 25 Nov 2006 05:56:58 -0700

DGJ wrote:

Hi
I have the task of importing a text file structured as below, into an
ADOdataset. Each record has a space between and a form feed char.
There may be anything up to 10,000 records.

Can anyone advise me what may be the easiest way?

Thanks

DGJ

Date: 21/02/2006
Name: peter john1
Jobno: 192332887
Cgref: 112340
Costing: addition
Model: CMC 4500
Comment: Installed
Location: WH Trostre
Status: not actioned

Date: 21/02/2006
Name: peter john2
Jobno: 194532887
Cgref: 112340
Costing:deletion
Model: CMC 4700
Comment: Installed
Location: WH Trostre
Status: not actioned

Read each record into a string.

Assign the string to the DelimitedText property of a TStringList. See
the on-line help for details.

Remove leading and trailing spaces with the Trim function.

Assign the value to the appropriate field in the dataset using the
..AsString property.

--
Bill Todd (TeamB)
.

References:
- Tex file import
  - From: DGJ

Prev by Date: Refreshing a current record in a DataSet
Next by Date: Re: Refreshing a current record in a DataSet
Previous by thread: Tex file import
Next by thread: Refreshing a current record in a DataSet
Index(es):
- Date
- Thread