Replace Text in a memo field

[ndt]

Hi,
This may or may not be an easy problem to solve as I'm relatively just
average with access.

What I have is a Memo field with html in it. It is a template I use
for selling items.

What I would like to do is run a query that will replace certain text
in the memo field using data stored in another access table but leave
the rest of the text "as is".

Any suggestions or let me know if you need more info...

 

[Douglas J. Steele]

Use the Replace function in your Update query:

UPDATE MyTable
SET MyField = Replace([MyField], "some old text", "some new text")
WHERE [MyField] LIKE "*some old text*"

 

[ndt]

I did this and my memo field has been drastically shortened. what
happened?

Use the Replace function in your Update query:

UPDATE MyTable
SET MyField = Replace([MyField], "some oldtext", "some newtext")
WHERE [MyField] LIKE "*some oldtext*"

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

Hi,
This may or may not be an easy problem to solve as I'm relatively just
average with access.

What I have is aMemofieldwith html in it. It is a template I use
for selling items.

What I would like to do is run a query that will replace certaintext
in thememofieldusing data stored in another access table but leave
the rest of thetext"as is".

Any suggestions or let me know if you need more info...- Hide quotedtext-

- Show quotedtext-

 

[Jeff Boyce]

We aren't there. We can't see what you're looking at.

"Drastically shortened" could mean so many different things. Care to
provide a real world example?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I did this and my memo field has been drastically shortened. what
happened?

Use the Replace function in your Update query:

UPDATE MyTable
SET MyField = Replace([MyField], "some oldtext", "some newtext")
WHERE [MyField] LIKE "*some oldtext*"

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

Hi,
This may or may not be an easy problem to solve as I'm relatively just
average with access.

What I have is aMemofieldwith html in it. It is a template I use
for selling items.

What I would like to do is run a query that will replace certaintext
in thememofieldusing data stored in another access table but leave
the rest of thetext"as is".

Any suggestions or let me know if you need more info...- Hide
quotedtext-

- Show quotedtext-

 

[ndt]

Originally it was truncated to a little over 300 characters but now
i'm seeing the whole thing, its working like a charm. Thanks so much,
this has literally saved me thousands of hours of work manually doing
it

We aren't there.  We can't see what you're looking at.

"Drastically shortened" could mean so many different things.  Care to
provide a real world example?

Regards

Jeff Boyce
Microsoft Office/Access MVP


I did this and my memo field has been drastically shortened. what
happened?

Use the Replace function in your Update query:

UPDATE MyTable
SET MyField = Replace([MyField], "some oldtext", "some newtext")
WHERE [MyField] LIKE "*some oldtext*"

- Show quotedtext-- Hide quoted text -

- Show quoted text -