String manypulation

[Guest_imported]

Hallo there,
Can anyone give me a thand with this?

I have a text file that has the following structure:

File name: name
Discription: club members
================================================
Member number: 0012
Member name: Icheron
Member ocupation: Student
Member subscribe date: 2-2-2001
================================================
Member number: 0358
Member name: Jones
Member ocupation: Programmer
Member subscribe date: 16-5-1999
================================================




What I need to know is how I can extract this informations and insert them into a database.

Can anyone help me!
tnx

 

[Guest_imported]

Me again,

The information I need to extract is:

Member number:
Member name:
Member ocupation:
Member subscribe date:

 

[kenhamady]

I don't think CR will do it, but you might look at a products like Monarch, or Data Junction. Or, you could run a couple of replace actions in MS Word to get this into a comma separated format.

Something iike Replace:

<CR> Member number: with a comma
(same for the other 3 label strings.

Then replace the <CR> equal sign string <CR> with just a single <CR>

You should end up with something like:
0012, Icheron, Student, 2-2-2001
0358, Jones, Programmer, 16-5-1999

This type of text file can easily be read by Excel or MS Access.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com