parsing a memo field

i am trying to parse a memo field in an existing database to many fields. i
have memo field of 6000 characters. The data in the memo has key words that
I would like to parse on. As an example, the words "Description" and "Tasks"
are placed above large pieces of text. I want to take all of the text after
"Description" and before "Tasks and place it in a separate field.

Any help you can give would be appreciated.

Does the word Tasks possibly exist in the text between the Description text
header and the Text text header? Can you show us an example of the data that
are in the memo field?

--

Ken Snell
MS ACCESS MVP

"Kai Leon" Kai wrote in message
...
i am trying to parse a memo field in an existing database to many fields. i
have memo field of 6000 characters. The data in the memo has key words
that
I would like to parse on. As an example, the words "Description" and
"Tasks"
are placed above large pieces of text. I want to take all of the text
after
"Description" and before "Tasks and place it in a separate field.

Any help you can give would be appreciated.

And are the same headings (what you called key words) always present and
always in the same order?

On Sun, 17 Dec 2006 08:23:54 -0500, "Ken Snell \(MVP\)"
wrote:

Does the word Tasks possibly exist in the text between the Description text
header and the Text text header? Can you show us an example of the data that
are in the memo field?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

On Sat, 16 Dec 2006 22:55:00 -0800, Kai Leon wrote:

i am trying to parse a memo field in an existing database to many fields. i
have memo field of 6000 characters. The data in the memo has key words that
I would like to parse on. As an example, the words "Description" and "Tasks"
are placed above large pieces of text. I want to take all of the text after
"Description" and before "Tasks and place it in a separate field.

Any help you can give would be appreciated.

If you are looking to parse from the first instance of the word
"Description" to the first instance of the word "Task", then:

NewField =
Mid([Paragraph],InStr([Paragraph],"Description"),InStr([Paragraph],
"Task") -InStr([Paragraph],"Description"))

The above will include the word "Description" but exclude the word
"Task".

To exclude the word "Description" change the above expression to:

NewField = Mid([Paragraph],InStr([Paragraph],"Description")+12 ,
InStr([Paragraph],"Task")-InStr([Paragraph],"Description") -12)

Change [paragraph] to whatever the actual name of your Memo field is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Fred, thank you. It worked.

"fredg" wrote:

On Sat, 16 Dec 2006 22:55:00 -0800, Kai Leon wrote:

i am trying to parse a memo field in an existing database to many fields. i
have memo field of 6000 characters. The data in the memo has key words that
I would like to parse on. As an example, the words "Description" and "Tasks"
are placed above large pieces of text. I want to take all of the text after
"Description" and before "Tasks and place it in a separate field.

Any help you can give would be appreciated.

If you are looking to parse from the first instance of the word
"Description" to the first instance of the word "Task", then:

NewField =
Mid([Paragraph],InStr([Paragraph],"Description"),InStr([Paragraph],
"Task") -InStr([Paragraph],"Description"))

The above will include the word "Description" but exclude the word
"Task".

To exclude the word "Description" change the above expression to:

NewField = Mid([Paragraph],InStr([Paragraph],"Description")+12 ,
InStr([Paragraph],"Task")-InStr([Paragraph],"Description") -12)

Change [paragraph] to whatever the actual name of your Memo field is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail