I am trying to find a word in a string field and put it in another field.
String = "Hello. My name is Sam Smith"
Key word = "Smith"
So, I want to update the field to be "Hello. My name is Sam "
Then, put the word "Smith" in a new field with in the row.