I have a table of company projects in which our company name is used repeatedly. 2 problems...
First, our name has changed and
Second, the name includes an ampersand and that is represented in the table three different ways:
1. as "&"
2. as "&"
3. as "&"
Is there a way to parse a text field and replace text automagically - I'm not looking forward to even think about doing this by hand.
For purposes of this question, there are 2 datatype text fields that need to be read - prj_ShortDescription and prj_LongDescription. Also for the sake of the question, say the company name is 'Peas & Carrots' and it is changing to 'Small Buttered Vegetables'.
Thus every instance of 'Peas & Carrots', 'Peas & Carrots' and 'Peas & Carrots' in fields prj_ShortDescription and prj_LongDescription would need to be changed to 'Small Buttered Vegetables'. There might even an extra space before or after the ampersand - I don't suspect this part is possible - I may just have to deal with the stragglers as I find them.
No rush on this - I won't be able to do anything with it until tomorrow morning - some 15+ hours hence. As always, thanks in advance for any help.