Find and Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I restrict what find locates in order to replace it. In other words, I'm trying to replace Co with company but when I run find for Co it finds every occurrence of the 2 letters co even when I put a space before and after the co.
 
Look for an option for 'Find Whole Word Only' in the search
dialog box.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
How would I restrict what find locates in order to replace
Click to expand...
it. In other words, I'm trying to replace Co with company
but when I run find for Co it finds every occurrence of the
2 letters co even when I put a space before and after the
co.
 
I guess the option I referred to is only there in the Code
Module search function and you must be referring to the
table data search.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Is this a one time Find/Replace? We may be able to come up
with some options on how to find what you need and replace
it with an Append query if there is some consistency to
where Co appears.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
You're probably correct. I'm just using the simple "Find
and Replace" on a table. It's an imported table with no
periods after abbreviations and I was trying to simplify
the corrections but I keep getting every instance of the
search letters.
 
Post a sample of the data you are working with.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
I'm not where the info is but it's just a table with
fields of company name,address,city,state, etc.

The field with company name has abbreviations with no
periods such as XYZ Co

I'm trying to find all Co and replace with Company but it
also picks up on Corp. I can't figure out how to limit it
to just Co

Hope I explained that OK...Thanks for your time.

E.B.
 
The field with company name has abbreviations with no
periods such as XYZ Co

I'm trying to find all Co and replace with Company but it
also picks up on Corp. I can't figure out how to limit it
to just Co
Click to expand...

You could use a criterion on an Update query of

LIKE "* Co"

to select all records where the field ends in a blank followed by the
letters Co; and update the field to

[CompanyName] & "mpany"

to update XYZ Co to XYZ Company.
 
It's a one time shot. It's just cleaning up an imported
file for use in a merge mail. One of the problems is that
there is no consistentcy, sometime there are spaces
following the letters and sometimes not.

Thanks again,
E.B.
 
Thanks,
I'll give that a try. As I'm asking these questions we
are doing some of them one by one. Hoepfully I'll figure
this out with your help before we finish.

Thanks again,
E.B>
 
Back
Top