AnsweredAssumed Answered

Data Base Find and Replace

Question asked by user15130 on Nov 2, 2011
Latest reply on Nov 2, 2011 by user15130

Title

Data Base Find and Replace

Post

If I have 3 fields that I want to do a find and replace on what would the case or if statment look like.  I have about 30,000 records and it needs to do the following:

 

Field 1 is now Doug and I need it to be replaced by Jonh

Field 1 is now Matt and I need it to be replaced by Chris

Field 1 is now Steve and I need it to be replaced by Tony

I want to script it so I can do it each week.  Each week I do an import of data and then I want to run this script to make the necessary find and replace.

 

Thank you

 

Marty

 

Outcomes