Jump to content
Sign in to follow this  
MacFileman

Find and Replace All

Recommended Posts

Hey...

I know the answer to this is super easy, feeling brain dead, but I think I have done this before ages ago and just forgot how.

How do I find and replace a text value in a record in all found sets? Obviously, I am look to do this in all records instantly, not one at a time. : )

Thanks,

Mike

 

 

Share this post


Link to post
Share on other sites

There are several possible answers. Could you give an example of what you're trying to do( and why)?

Share this post


Link to post
Share on other sites

Specifically need to change the salesman in a particular field. It has always been a pull down menu, but some co-workers decided to manually enter the name through the years. This has been fixed and it can no longer be manually edited in a form, pull down option only for consistency.

So... a salesmen named "William" is also named "Bill" throughout 100's of records. I want to make them all "William."

Why is this important? Easier to find all "William's" customers for reporting than have to search in both names. Scripting purposes and so fourth.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

Yup! Find and Replace.... pretty simple. Felt dumb for asking, but like I said...I was brain dead and forgot that was available.

Share this post


Link to post
Share on other sites

Well, assuming this only needs to be done once, I would find the records where the name is "Bill", type "William" in one record and do Records > Replace Field Contents… > Replace with: "William".

Keep in mind that there's no undo after either method.

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.