Someone else can pipe in and say if they know of a class that does this but my first reaction was that it would probably have to be fairly specific code depending on what you want to do.

One form that I have set up for a customer had to do with a search and replace for updating the domain name portion of email addresses. This happens in their industry (insurance) where there are a fair number of mergers going on on a regular basis. They wanted to change just the domain portion.

To make sure they did not mess up the data inadvertently, the form:

- has a field for the original domain name
- has a field for the new domain name

and this is where some safeguards were built in:

- the user has to press "search" first which shows a listing in a grid of all the matches found for the original domain name
- before they can proceed, they have to do a "test replace" which shows the addresses with the replacement as it would be

So I would build in some safeguards based upon the data they are updating. If the data is critical enough, you might even copy out the data that is being changed to a backup folder in some sort of data file - I do this when this customer sometimes asks me to get rid of data - I just copy it out as a free table with the primary key and the changed field - it gives me a backup if they happen to say "is there any way we can get that data back" - people change their minds! (in this case, it is mailing lists where they say to purge such and such).

Good luck. I will attach a screen shot of the tool this customer uses.

Albert

>Hi All,
>
>A customer has asked to have a 'Find and Replace' feature to replace data of various types in a table.
>Is there some code out there that I can just drop in?
>Thanks.
>
>Luke