Is it possible to extract data from a field?

[Carol]

I had posted a question before and someone tried to help
me, but it involved writing code, and I don't know how to
write code!

I'm trying to take certain data from a text description
in a field and extract the specific data and put it in
it's own field. Is it possible to do this without
writing code to make it happen?

For example, there is text and at the end of the text,
there are a few codes. Those codes need to be "cut" out
of that field and "pasted" into another, but still
correspond with the appropriate text description. There
are thousands of descriptions, so I'm not able to do this
manually.

Please help!!

 

[Joseph Meehan]

I am assuming you want just part of one field and you want to put it
into another field.

Tell me in English how I would know what data you want to extract. Give
us a few examples. Remember, I must be able to find all the data in all the
records you want to extract with no knowledge other than exactly what you
are going to tell me. If you can't do this, you will not be able to tell
Access how to do it.

Will the field you are extracting from change after you do the
extraction? If so do you want the child field to change as well?

Are you aware, that you may not need to have an additional field and if
so you don't want one?

 

[John Vinson]

I had posted a question before and someone tried to help
me, but it involved writing code, and I don't know how to
write code!

I'm trying to take certain data from a text description
in a field and extract the specific data and put it in
it's own field. Is it possible to do this without
writing code to make it happen?

Not that I can see. It will hopefully be fairly simple code, which
someone here can write for you so that you can copy and paste it into
a Module in your database and use it - but in order for that to be
possible you will need to post some more details, such as the name of
your tables (including the table containing the codes and their
descriptions), their Primary Key field names, how they are related,
the name of the field that you want to cut from and paste to.

Basically, you're trying to take non-normalized data (multiple values
stored not only in a single record, but even worse in a single field
along with other data) and convert it to normalized data. This is a
laudable goal, but unfortunately it's not a trivial, point-and-shoot
operation.

 

[Tom Wickerath]

Carol,

If you can send me a copy of your database, I will try to help you with this goal. I have
Access 97, 2000 and 2002 available.


Tom

AOS168 AT Comcast Dot Net

_______________________________________


I had posted a question before and someone tried to help
me, but it involved writing code, and I don't know how to
write code!

I'm trying to take certain data from a text description
in a field and extract the specific data and put it in
it's own field. Is it possible to do this without
writing code to make it happen?

For example, there is text and at the end of the text,
there are a few codes. Those codes need to be "cut" out
of that field and "pasted" into another, but still
correspond with the appropriate text description. There
are thousands of descriptions, so I'm not able to do this
manually.

Please help!!

 

[Elsa]

You have to use a query and insert a new coloumn. In this
column you would for example to the following:

Let us say the code is

KLN8907 XP2000

Right(

,4) will extract 2000
Mid([code],9,2) will extraxt XP
Mid([code],instr([code]," ")+ 1,Len([code]))  will extract
from where it found a space, go one more character and
then from there extract everything for the rest of the code

Hope this helps!