update only part of a field?

R

Robbie

Is there a way to update only part of a field? During a recent update one of
the fields in a db we import products to had some spelling errors.

The problem is that I can't just update the field with the correct spelling
because only one of the words is wrong and they don't all have the same
info.

ie. Bondeded Leather colorvalue

Is there a way to to just fix the bondeded leather part and leave the
colorvalue or anything before/after those words alone?
 
K

KARL DEWEY

In the update query use this in the Update To row for the field --
Replace([YourFieldName], "Bondeded", "Bonded")

Remember to always backup before doing any gobal changes.
 
A

Allen Browne

In your Update query, enter an expression like this in the Update row under
your field (named "f" in this example):
Replace([f], "Bondeded Leather", "Bonded Leather")

To avoid unnecessary updates, you could set the Critiera to:
Like "*Bondeded Leather*"
 
R

Robbie

Thanks a lot.

Allen Browne said:
In your Update query, enter an expression like this in the Update row
under your field (named "f" in this example):
Replace([f], "Bondeded Leather", "Bonded Leather")

To avoid unnecessary updates, you could set the Critiera to:
Like "*Bondeded Leather*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Robbie said:
Is there a way to update only part of a field? During a recent update one
of the fields in a db we import products to had some spelling errors.

The problem is that I can't just update the field with the correct
spelling because only one of the words is wrong and they don't all have
the same info.

ie. Bondeded Leather colorvalue

Is there a way to to just fix the bondeded leather part and leave the
colorvalue or anything before/after those words alone?
Click to expand...
Click to expand...
 
Top