Hi,

I have a voice recording program with an associated text editor which
can add notes and comments to a text file, stamping them with the time
elapsed in the recording when the comment was added. The program will
be used to record a daily meeting, and add time-stamped comments to
each file. I am attempting to create a database which will hold each
time stamp as an individual record in a table, along with the location
and filename of that day's meeting audio, saved a mp3. Users will
then be able to search the database for particular comments, retrieve
the relevant .mp3, and fast forward to the correct point in the audio.

I can export the text to a .txt file, which displays as follows:

0:00:00 [15:55:54] Start Recording
0:00:02 [15:55:56] Note 1.
Recording details for Note 1

0:00:25 [15:56:19] Note 2.
Recording details for Note 2

0:00:44 [15:56:37] Stop Recording
0:00:44 [15:56:40] Start Recording
0:00:47 [15:56:43] Note 3.
recording details for note 3

0:00:59 [15:56:55] Stop Recording

As you can see, this poses some problems for import into Access.
1. The Recording details for each note are put on the line below that
note, rather than as a 4th field.
2. Recording time, actual time and note heading are delimited only by
a space, not by a tab, comma or semicolon.

Addressing point 2 first, i can import the data into a table in fixed
length format, as follows:

RecTime ActualTime NoteName NoteComment
0:00:00 [15:55:54] Start Recording
0:00:02 [15:55:56] Note 1.
Recordin g details f or Note 1

0:00:25 [15:56:19] Note 2.
Recordin g details f or Note 2

0:00:44 [15:56:37] Stop Recording
0:00:44 [15:56:40] Start Recording
0:00:47 [15:56:43] Note 3.
recordin g details f or note 3

0:00:59 [15:56:55] Stop Recording

Back to point 1, what I need to do now is to remove the blank records
(easy), then run some code or a query to determine whether, for each
record, RecTime is a recording time or the first part of a
NoteComment. If it is a NoteComment, I need to concatenate it with
ActualTime and NoteName to give the full NoteComment, then put this
concatenated comment into the NoteComment field of the record above.
I have tried doing this using recordsets, but, although this seems
like the right way, I have as yet had no luck.

I would very much appreciate any help on this.

Regards

Dom Boyce

domboyce (AT) totalise (DOT) co.uk (Dom Boyce) wrote in message news:<7c016cf5.0311190858.43a11bd3 (AT) posting (DOT) google.com>...

Option one: using whatever reporting tool you use now, find out how to
export the fields of a record all on one line.

Option two: using the file format you have now, reformat using a PERL
script (or if you cannot run PERL, write it in C or C++, It really
should not be too hard).

Option three: manually edit the file with a decent editor.

Yes my answers were vague, but you fail to let us know any necessary
information to help: what platform (Note, not everyone runs windoze),
what database, what reporting tool/language. In my environment the
answer to your problem would be PERL.

HTH,
ed

ed.prochak (AT) magicinterface (DOT) com (Ed prochak) wrote in message news:<4b5394b2.0311201042.5e973105 (AT) posting (DOT) google.com>...

Sorry, as I mentioned in the post, I am using Access. This is version
2002 running on Win 2K, and the solution should be created using VBA
and Access queries, if possible. Thanks

domboyce (AT) totalise (DOT) co.uk (Dom Boyce) wrote in message news:<7c016cf5.0311210804.67101954 (AT) posting (DOT) google.com>...
Since you are using Access 2K2, look up the fileSystemObject and the
TextStreamObject in VBA help. In particular, the ReadLine function
should help.

Bob

Hi

Maybe u should try a crosstab query that will do just that.




rmitchell (AT) jcproduce (DOT) com (Bob) wrote in message news:<93f80c14.0311211611.38762210 (AT) posting (DOT) google.com>...