Cutting data from a field

[JA]

Hi,

I have an expression (2 actually) to move some text from one field to
another. It moves the part after the ":" (colon).

Left([ProductName], InStr([ProductName], ":") - 1)

Mid([ProductName], InStr([ProductName], ":") + 1)

I have to move some other text from one field to another. The text always
starts with "product description", and goes to the end of the field, but it
can be really, really long! And it is from one memo field to another, rather
than text fields. Can I just adapt the above expressions like this:?
Left([ProductDetail], InStr([ProductName], "Product Description") - 1)

Mid([ProductDetail], InStr([ProductName], "Product Description") + 1)
Thanks, J~

[Rick Brandt]

JA wrote:

Hi,

I have an expression (2 actually) to move some text from one field to
another. It moves the part after the ":" (colon).

Left([ProductName], InStr([ProductName], ":") - 1)

Mid([ProductName], InStr([ProductName], ":") + 1)

I have to move some other text from one field to another. The text
always starts with "product description", and goes to the end of the
field, but it can be really, really long! And it is from one memo
field to another, rather than text fields. Can I just adapt the above
expressions like this:?

Left([ProductDetail], InStr([ProductName], "Product Description")
- 1)
Mid([ProductDetail], InStr([ProductName], "Product Description")
+ 1)

Thanks, J~

You only need one expression. Since "Product Description" is always 19
characters long all you need is...

Mid([ProductDetail], 20)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[JA]

It isn't just the words "product description" that I need to move. The text
just always start out with that. I need to move everything from "product
description" on till the end of the record. And it isn't ever a set amount
of characters. So would that still work?

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:27******************@newssvr25.news.prodigy.n et...

JA wrote:

>Hi,

I have an expression (2 actually) to move some text from one field to
another. It moves the part after the ":" (colon).

Left([ProductName], InStr([ProductName], ":") - 1)

Mid([ProductName], InStr([ProductName], ":") + 1)

I have to move some other text from one field to another. The text
always starts with "product description", and goes to the end of the
field, but it can be really, really long! And it is from one memo
field to another, rather than text fields. Can I just adapt the above
expressions like this:?

Left([ProductDetail], InStr([ProductName], "Product Description")
- 1)
Mid([ProductDetail], InStr([ProductName], "Product Description")
+ 1)

Thanks, J~

You only need one expression. Since "Product Description" is always 19
characters long all you need is...

Mid([ProductDetail], 20)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Rick Brandt]

JA wrote:

It isn't just the words "product description" that I need to move.
The text just always start out with that. I need to move everything
from "product description" on till the end of the record. And it
isn't ever a set amount of characters. So would that still work?

Mid([ProductDetail], 20)

....returns all characters from the 20th one on until the end of supplied string.

(so yes)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Larry Linson]

"JA" <ja*****@kc.rr.comwrote

It isn't just the words "product description"
that I need to move. The text just always start
out with that. I need to move everything from
"product description" on till the end of the
record. And it isn't ever a set amount of
characters. So would that still work?

Just an idle question: As "product description" is a label or identification
of the information that follows, and is the same for each record, do you
really need to extract that, too? Or have I misunderstood and the text you
are moving from the Memo field may contain other types of information in
addition to the description of the product?

Larry Linson
Microsoft Access MVP